SQL: Show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics
SQL Basic Select Statement : Exercise-20 with Solution.
Write a SQL query to show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics.
Sample table : nobel_win
Sample Solution :
SELECT * FROM nobel_win WHERE year=1970 AND subject NOT IN('Physiology','Economics');
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL query to show all the winners in Physics for 1970 together with the winner of Economics for 1971.
Next: Write a SQL query to show the winners of a 'Physiology' prize in an early year before 1971 together with winners of a 'Peace' prize in a later year on and after the 1974.
What is the difficulty level of this exercise?