SQLZOO习题答案 The nobel table can be used to practice more SUM and COUNT functions./zh
1.找出總共有多少個獎頒發了。SELECT COUNT(winner) FROM nobel2.列出每一個獎項(subject), 只列一次select distinct(subject) from nobel3.找出物理獎的總頒發次數。select count(subject)
from nobel
where subject ='physics'4.對每一個獎項(Subjec
原创
2017-11-13 15:19:41 ·
2319 阅读 ·
0 评论