Question

Rupam created a MySQL table to store the details of Nobel prize winners. Help her to write the following MySQL queries: 

                                                      TABLE: NOBEL

Winner_Id	YEAR	SUBJECT	WINNER	COUNTRY	CATEGORY
1001	1970	Physics	Hannes Alfven	Sweden	Scientist
1002	1970	Physiology	Bernard Katz	NULL	Scientist
1003	1970	Literature	Aleksandr Solzhenitsyn	Russia	Linguist
1004	1971	Chemistry	Gerhard Herzberg	Germany	Scientist
1005	1978	Peace	Menachem Begin	Israel	Prime Minister
1006	1987	Economics	Robert Solow	USA	Economist
1007	1994	Literature	Kenzaburo Oe	Japan	Linguist

1. Display the names of Nobel Prize winner in 'Literature' for the year 1970.
2. Display the subject and category of winners whose country is not known.
3. Display the details of all Nobel Prize winners who were Scientists.
4. Count total number of winners whose subject is Literature.

Answer 1

1. SELECT WINNER FROM NOBEL WHERE YEAR = 1970 AND SUBJECT = 'Literature';
2. SELECT SUBJECT, CATEGORY FROM NOBEL WHERE COUNTRY IS NULL;
3. SELECT * FROM NOBEL WHERE CATEGORY = 'Scientist';
4. SELECT COUNT(*) FROM NOBEL WHERE SUBJECT = 'Literature';