SQLZOO习题答案 The nobel table can be used to practice more SUM and COUNT functions./zh

1.找出總共有多少個獎頒發了。

SELECT COUNT(winner) FROM nobel

2.列出每一個獎項(subject), 只列一次

select distinct(subject) from nobel

3.找出物理獎的總頒發次數。

select count(subject)
    from  nobel 
    where subject ='physics'

4.對每一個獎項(Subject),列出頒發數目