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.
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
Output of the Query:
need an explanation for this answer? contact us directly to get an explanation for this answer