w3resource
SQL exercises

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');

Output :

SQL exercises

Query Visualization:

Duration:

Query visualization of Show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics - Duration

Rows:

Query visualization of Show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics - Rows

Cost:

Query visualization of Show all the winners of nobel prize in the year 1970 except the subject Physiology and Economics - Cost

Practice Online


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?



New Content: Composer: Dependency manager for PHP, R Programming