SQL: Detailed information on the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin

SQL Basic Select Statement: Exercise-17 with Solution.

Write a SQL query to display all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin.

Sample table: nobel_win

Sample Solution:

SELECT * FROM nobel_win
 WHERE year >1972
  AND winner IN ('Menachem Begin',
                  'Yitzhak Rabin');

Output of the Query:

year	subject	winner		country	category
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 ‘Chemistry’ between the years 1965 to 1975. Begin and end values are included. Return year, subject, winner, and country.
Next: From the following table, write a SQL query to find the details of the winners whose first name matches with the string 'Louis'. Return year, subject, winner, country, and category.