http://nice-learning.net/nlWiki/index.php?action=history&feed=atom&title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4%2F01%2F%E6%88%90%E7%B8%BE
不錯學群/01/成績 - 修訂歷史
2026-05-01T21:11:15Z
本 Wiki 上此頁面的修訂歷史
MediaWiki 1.34.2
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4949&oldid=prev
丁志仁：/* 評分SQL */
2021-02-07T14:04:25Z
<p><span dir="auto"><span class="autocomment">評分SQL</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月7日 (日) 14:04 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l107" >行 107：</td>
<td colspan="2" class="diff-lineno">行 107：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第42題，SELECT name,answerCorrect*30 FROM testAnswers WHERE tid=38 AND 題號=42 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第42題，SELECT name,answerCorrect*30 FROM testAnswers WHERE tid=38 AND 題號=42 group by name</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#給新埔國中成績：http://nice-learning.tw/NL/nlGradesMaker.php</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====曉祺沒有修藝術領域學分====</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====曉祺沒有修藝術領域學分====</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#先求月考藝術類考題平均分數：select a.name,a.tid,a.題號,avg(answerCorrect)*50,Subject from testAnswers a left join testQuestions q on concat(a.tid,a.題號)=concat(q.tid,q.題號) where q.Subject like '%藝%' && a.name='歐陽曉祺' && a.tid>36</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#先求月考藝術類考題平均分數：select a.name,a.tid,a.題號,avg(answerCorrect)*50,Subject from testAnswers a left join testQuestions q on concat(a.tid,a.題號)=concat(q.tid,q.題號) where q.Subject like '%藝%' && a.name='歐陽曉祺' && a.tid>36</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#得到 80 分，拿來當曉祺所修藝術領域學分的平均分數</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#得到 80 分，拿來當曉祺所修藝術領域學分的平均分數</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#套入領域學分佔 80% ，月考佔 20% 的佔比求總平均。由於曉祺第一次月考缺考，是補考過的，所以藝術領域成績會比八十分略低。</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#套入領域學分佔 80% ，月考佔 20% 的佔比求總平均。由於曉祺第一次月考缺考，是補考過的，所以藝術領域成績會比八十分略低。</div></td></tr>
<!-- diff cache key nlWiki-wiki_:diff::1.12:old-4948:rev-4949 -->
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4948&oldid=prev
丁志仁：/* 曉祺沒有修藝術領域學分 */
2021-02-07T13:46:01Z
<p><span dir="auto"><span class="autocomment">曉祺沒有修藝術領域學分</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月7日 (日) 13:46 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l108" >行 108：</td>
<td colspan="2" class="diff-lineno">行 108：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====曉祺沒有修藝術領域學分====</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>====曉祺沒有修藝術領域學分====</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#先求月考藝術類考題平均分數：select a.name,a.tid,a.題號,avg(answerCorrect)*50,Subject from testAnswers a left join testQuestions q</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#先求月考藝術類考題平均分數：select a.name,a.tid,a.題號,avg(answerCorrect)*50,Subject from testAnswers a left join testQuestions q on concat(a.tid,a.題號)=concat(q.tid,q.題號) where q.Subject like '%藝%' && a.name='歐陽曉祺' && a.tid>36</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>on concat(a.tid,a.題號)=concat(q.tid,q.題號) where <del class="diffchange diffchange-inline"> </del>q.Subject like '%藝%' && a.name='歐陽曉祺' && a.tid>36</div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#得到 80 分，拿來當曉祺所修藝術領域學分的平均分數</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#得到 80 分，拿來當曉祺所修藝術領域學分的平均分數</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#套入領域學分佔 80% ，月考佔 20% 的佔比求總平均。由於曉祺第一次月考缺考，是補考過的，所以藝術領域成績會比八十分略低。</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#套入領域學分佔 80% ，月考佔 20% 的佔比求總平均。由於曉祺第一次月考缺考，是補考過的，所以藝術領域成績會比八十分略低。</div></td></tr>
<!-- diff cache key nlWiki-wiki_:diff::1.12:old-4947:rev-4948 -->
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4947&oldid=prev
丁志仁：/* 評分SQL */
2021-02-07T13:45:23Z
<p><span dir="auto"><span class="autocomment">評分SQL</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月7日 (日) 13:45 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l107" >行 107：</td>
<td colspan="2" class="diff-lineno">行 107：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第42題，SELECT name,answerCorrect*30 FROM testAnswers WHERE tid=38 AND 題號=42 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第42題，SELECT name,answerCorrect*30 FROM testAnswers WHERE tid=38 AND 題號=42 group by name</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">====曉祺沒有修藝術領域學分====</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#先求月考藝術類考題平均分數：select a.name,a.tid,a.題號,avg(answerCorrect)*50,Subject from testAnswers a left join testQuestions q</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">on concat(a.tid,a.題號)=concat(q.tid,q.題號) where q.Subject like '%藝%' && a.name='歐陽曉祺' && a.tid>36</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#得到 80 分，拿來當曉祺所修藝術領域學分的平均分數</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">#套入領域學分佔 80% ，月考佔 20% 的佔比求總平均。由於曉祺第一次月考缺考，是補考過的，所以藝術領域成績會比八十分略低。</ins></div></td></tr>
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4867&oldid=prev
丁志仁 於 2021年2月4日 (四) 01:21
2021-02-04T01:21:55Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月4日 (四) 01:21 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >行 1：</td>
<td colspan="2" class="diff-lineno">行 1：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[分類:評量]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[分類:評量]]</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">===學分成績單===</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><table class=nicetable></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><table class=nicetable></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>孫伯罕</td><td>GIS</td><td>88</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>孫伯罕</td><td>GIS</td><td>88</td></tr></div></td></tr>
<!-- diff cache key nlWiki-wiki_:diff::1.12:old-4866:rev-4867 -->
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4866&oldid=prev
黃鈴諭 於 2021年2月4日 (四) 01:19
2021-02-04T01:19:26Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月4日 (四) 01:19 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l63" >行 63：</td>
<td colspan="2" class="diff-lineno">行 63：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>歐陽曉祺</td><td>英文</td><td>82</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>歐陽曉祺</td><td>英文</td><td>82</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>歐陽曉祺</td><td>資訊基礎運用</td><td>85</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>歐陽曉祺</td><td>資訊基礎運用</td><td>85</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>FPS電競社</td><td><del class="diffchange diffchange-inline">0</del></td></tr></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>FPS電競社</td><td><ins class="diffchange diffchange-inline">74</ins></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>GIS</td><td>100</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>GIS</td><td>100</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>全班共讀</td><td>60</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>全班共讀</td><td>60</td></tr></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79" >行 79：</td>
<td colspan="2" class="diff-lineno">行 79：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>資訊基礎運用</td><td>95</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>資訊基礎運用</td><td>95</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>跨視界漫想</td><td>92</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>潘宗儀</td><td>跨視界漫想</td><td>92</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><tr><td>薛期蔚</td><td>FPS電競社</td><td><del class="diffchange diffchange-inline">0</del></td></tr></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><tr><td>薛期蔚</td><td>FPS電競社</td><td><ins class="diffchange diffchange-inline">66</ins></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>薛期蔚</td><td>GIS</td><td>0</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>薛期蔚</td><td>GIS</td><td>0</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>薛期蔚</td><td>全班共讀</td><td>80</td></tr></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr><td>薛期蔚</td><td>全班共讀</td><td>80</td></tr></div></td></tr>
<!-- diff cache key nlWiki-wiki_:diff::1.12:old-4865:rev-4866 -->
</table>
黃鈴諭
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4865&oldid=prev
丁志仁：/* 評分SQL */
2021-02-04T00:57:16Z
<p><span dir="auto"><span class="autocomment">評分SQL</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月4日 (四) 00:57 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l104" >行 104：</td>
<td colspan="2" class="diff-lineno">行 104：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#分數加減實作：SELECT name,pow(avg(answerCorrect)*50,0.5)*10 FROM `testAnswers` WHERE `tid` = '37' AND 題號=41 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#分數加減實作：SELECT name,pow(avg(answerCorrect)*50,0.5)*10 FROM `testAnswers` WHERE `tid` = '37' AND 題號=41 group by name</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#GIS 第38次月考</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#GIS 第38次月考</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%<del class="diffchange diffchange-inline">：第42題，</del></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%<ins class="diffchange diffchange-inline">：第42題，SELECT name,answerCorrect*30 FROM testAnswers WHERE tid=38 AND 題號=42 group by name</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td></tr>
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4864&oldid=prev
丁志仁：/* 評分SQL */
2021-02-04T00:53:36Z
<p><span dir="auto"><span class="autocomment">評分SQL</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月4日 (四) 00:53 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l102" >行 102：</td>
<td colspan="2" class="diff-lineno">行 102：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#總分(上表)：SELECT 學生,項目,ROUND(avg(成績)) FROM nlGrades group by 學生,項目 order by 學生</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#總分(上表)：SELECT 學生,項目,ROUND(avg(成績)) FROM nlGrades group by 學生,項目 order by 學生</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#理財入門：SELECT name,pow(avg(answerCorrect)*50,0.5)*10+4 FROM testAnswers WHERE tid=37 AND (題號>=1 && 題號<=14) group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#理財入門：SELECT name,pow(avg(answerCorrect)*50,0.5)*10+4 FROM testAnswers WHERE tid=37 AND (題號>=1 && 題號<=14) group by name</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#<del class="diffchange diffchange-inline">分數加減：SELECT </del>name,pow(avg(answerCorrect)*50,0.5)*10 FROM `testAnswers` WHERE `tid` = '37' AND 題號=41 group by name</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#<ins class="diffchange diffchange-inline">分數加減實作：SELECT </ins>name,pow(avg(answerCorrect)*50,0.5)*10 FROM `testAnswers` WHERE `tid` = '37' AND 題號=41 group by name</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#GIS 第38次月考</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#GIS 第38次月考</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第42題，</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第42題，</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第24~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td></tr>
<!-- diff cache key nlWiki-wiki_:diff::1.12:old-4863:rev-4864 -->
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4863&oldid=prev
丁志仁：/* 評分SQL */
2021-02-04T00:53:06Z
<p><span dir="auto"><span class="autocomment">評分SQL</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月4日 (四) 00:53 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l103" >行 103：</td>
<td colspan="2" class="diff-lineno">行 103：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#理財入門：SELECT name,pow(avg(answerCorrect)*50,0.5)*10+4 FROM testAnswers WHERE tid=37 AND (題號>=1 && 題號<=14) group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#理財入門：SELECT name,pow(avg(answerCorrect)*50,0.5)*10+4 FROM testAnswers WHERE tid=37 AND (題號>=1 && 題號<=14) group by name</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#分數加減：SELECT name,pow(avg(answerCorrect)*50,0.5)*10 FROM `testAnswers` WHERE `tid` = '37' AND 題號=41 group by name</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#分數加減：SELECT name,pow(avg(answerCorrect)*50,0.5)*10 FROM `testAnswers` WHERE `tid` = '37' AND 題號=41 group by name</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#GIS</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#GIS <ins class="diffchange diffchange-inline">第38次月考</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%<del class="diffchange diffchange-inline">：第38次月考第42題，</del></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%<ins class="diffchange diffchange-inline">：第42題，</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%<del class="diffchange diffchange-inline">：第38次月考第24</del>~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 </div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%<ins class="diffchange diffchange-inline">：第24</ins>~27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 group by name</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>group by name</div></td><td colspan="2"> </td></tr>
<!-- diff cache key nlWiki-wiki_:diff::1.12:old-4862:rev-4863 -->
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4862&oldid=prev
丁志仁：/* 評分SQL */
2021-02-04T00:52:19Z
<p><span dir="auto"><span class="autocomment">評分SQL</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月4日 (四) 00:52 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l105" >行 105：</td>
<td colspan="2" class="diff-lineno">行 105：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#GIS</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#GIS</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第38次月考第42題，</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>#*實作佔 60%：第38次月考第42題，</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第38次月考第24~<del class="diffchange diffchange-inline">27題，</del></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>#*筆試佔 40%：第38次月考第24~<ins class="diffchange diffchange-inline">27題，SELECT name,sum(answerCorrect*5) FROM testAnswers WHERE tid=38 AND 題號<=27 AND 題號>=24 </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">group by name</ins></div></td></tr>
<!-- diff cache key nlWiki-wiki_:diff::1.12:old-4861:rev-4862 -->
</table>
丁志仁
http://nice-learning.net/nlWiki/index.php?title=%E4%B8%8D%E9%8C%AF%E5%AD%B8%E7%BE%A4/01/%E6%88%90%E7%B8%BE&diff=4861&oldid=prev
丁志仁 於 2021年2月4日 (四) 00:44
2021-02-04T00:44:07Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="zh-Hant-TW">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">←上個修訂</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">於 2021年2月4日 (四) 00:44 的修訂</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l99" >行 99：</td>
<td colspan="2" class="diff-lineno">行 99：</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></table></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></table></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">得自：</del></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">===評分SQL===</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#總分(上表)：SELECT </ins>學生,項目,ROUND(avg(成績)) FROM nlGrades group by 學生,項目 order by 學生</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">SELECT </del>學生,項目,ROUND(avg(成績))</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#理財入門：SELECT name,pow(avg(answerCorrect)*50,0.5)*10+4 FROM testAnswers WHERE tid=37 AND (題號>=1 && 題號<=14) group by name</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>FROM nlGrades</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#分數加減：SELECT name,pow(avg(answerCorrect)*50,0.5)*10 FROM `testAnswers` WHERE `tid` = '37' AND 題號=41 group by name</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>group by 學生,項目 order by 學生</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#GIS</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#*實作佔 60%：第38次月考第42題，</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">#*筆試佔 40%：第38次月考第24~27題，</ins></div></td></tr>
</table>
丁志仁