Quiz Trial

SQL Quiz

Question 1

Table Structure:

nobel(yr, subject, winner)

Name the winner(s) of the Nobel prize in Chemistry in 2001. Sort their names alphabetically.

Question 2

Tables Example:

ttms games color who country 1988 gold Yoo Nam-Kyu KOR 1988 silver Kim Ki Taik KOR .. .. .. ..

country id name ALG Algeria ARG Argentina ... ... KOR Korea .. ..

How many medals did each country win in this database? (Make sure to list countries by their name and not their ID.)