Q:

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

0

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.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions


need a help?


find thousands of online teachers now