SQL: The winners of a 'Physiology' prize in an early year before 1971 are shown in conjunction with the winners of a 'Peace' prize in a later year following the 1974

SQL Basic Select Statement: Exercise-21 with Solution.

From the following table, write a SQL query to combine the winners in 'Physiology' before 1971 and winners in 'Peace' on or after 1974. Return year, subject, winner, country, and category.

Sample table: nobel_win

Sample Solution:

SELECT * FROM nobel_win WHERE (subject ='Physiology' AND year<1971) UNION (SELECT * FROM nobel_win WHERE (subject ='Peace' AND year>=1974));

Output of the Query:

year	subject		winner		country	category
1970	Physiology	Bernard Katz	Germany	Scientist
1970	Physiology	Julius Axelrod	USA	Scientist
1970	Physiology	Ulf von Euler	Sweden	Scientist
1978	Peace		Anwar al-Sadat	Egypt	President
1978	Peace		Menachem Begin	Israel	Prime Minister
1994	Peace		Yitzhak Rabin	Israel	Prime Minister

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find the Nobel Prize winners in 1970 excluding the subjects Physiology and Economics. Return year, subject, winner, country, and category.
Next: From the following table, write a SQL query to find the details of the Nobel Prize winner 'Johannes Georg Bednorz'. Return year, subject, winner, country, and category.