SQL: Find all the details of the nobel winners for the subject not started with the letter 'P' and arranged the list as the most recent comes first, then by name in order
SQL Basic Select Statement: Exercise-23 with Solution.
Write a SQL query to find all the details of the nobel winners for the subject not started with the letter 'P' and arranged the list as the most recent comes first, then by name in order.
Sample table : nobel_win
Sample Solution :
SELECT * FROM nobel_win WHERE subject NOT LIKE 'P%' ORDER BY year DESC, winner;
Output of the Query:
year subject winner country category 1994 Literature Kenzaburo Oe Japan Linguist 1994 Economics Reinhard Selten Germany Economist 1987 Chemistry Donald J. Cram USA Scientist 1987 Chemistry Jean-Marie Lehn France Scientist 1987 Literature Joseph Brodsky Russia Linguist 1987 Economics Robert Solow USA Economist 1971 Chemistry Gerhard Herzberg Germany Scientist 1971 Literature Pablo Neruda Chile Linguist 1971 Economics Simon Kuznets Russia Economist 1970 Literature Aleksandr Solzhenitsyn Russia Linguist 1970 Chemistry Luis Federico Leloir France Scientist 1970 Economics Paul Samuelson USA Economist
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL query to find all details of the prize won by Johannes Georg Bednorz.
Next: Write a SQL query to find all the details of 1970 winners by the ordered to subject and winner name; but the list contain the subject Economics and Chemistry at last.
What is the difficulty level of this exercise?