SQL WHERE Exercises
Table - 'Noble' :
YEAR SUBJECT WINNER COUNTRY CATEGORY
---- ------------------------- --------------------------------------------- ------------------------- ------------
1970 Physics Hannes Alfven Sweden Scientist
1970 Physics Louis Neel France Scientist
1970 Chemistry Luis Federico Leloir France Scientist
1970 Physiology Ulf von Euler Sweden Scientist
1970 Physiology Bernard Katz Germany Scientist
1970 Literature Aleksandr Solzhenitsyn Russia Linguist
1970 Economics Paul Samuelson USA Economist
1970 Physiology Julius Axelrod USA Scientist
1971 Physics Dennis Gabor Hungary Scientist
1971 Chemistry Gerhard Herzberg Germany Scientist
1971 Peace Willy Brandt Germany Chancellor
1971 Literature Pablo Neruda Chile Linguist
1971 Economics Simon Kuznets Russia Economist
1978 Peace Anwar al-Sadat Egypt President
1978 Peace Menachem Begin Israel Prime Minister
1987 Chemistry Donald J. Cram USA Scientist
1987 Chemistry Jean-Marie Lehn France Scientist
1987 Physiology Susumu Tonegawa Japan Scientist
1994 Economics Reinhard Selten Germany Economist
1994 Peace Yitzhak Rabin Israel Prime Minister
1987 Physics Johannes Georg Bednorz Germany Scientist
1987 Literature Joseph Brodsky Russia Linguist
1987 Economics Robert Solow USA Economist
1994 Literature Kenzaburo Oe Japan Linguist
Problems :
Write a SQL query to display the Nobel prizes for 1971
Write a SQL query to know the winner of the 1970 prize for Literature.
Write a SQL query to display the year and subject that won 'Joseph Brodsky' his prize.
Write a SQL query to give the name of the 'Economics' winners since the year 1950.
Write a SQL query to Show all the details (year, subject, winner, country ) of the Literature prize winners between the year 1960 to 1971
Write a SQL query to show all the details of the winners with first name Robert.
Write a SQL query to show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics.
Write a SQL query to find all the details of the nobel winners for the Winners not starting with the letter 'J' and arranged the list as the most recent comes first, then by name in order.
Select the data of the Winners who have character āsā in 3rd place in their name.
Write a SQL query to show all the details of the winners with country 'France' and 'Germany'.
Write a SQL to show all the winners of nobel prize in Economics who are from USA.
Last updated
Was this helpful?