w3resource
SQL exercises

SQL: Show all details of 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 show 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:

SQL exercises

Query Visualization:

Duration:

Query visualization of Show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin - Duration

Rows:

Query visualization of Show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin - Rows

Cost:

Query visualization of Show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin - 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 details (year, subject, winner, country ) of the Chemistry prize winners between the year 1965 to 1975 inclusive.
Next: Write a SQL query to show all the details of the winners with first name Louis.

What is the difficulty level of this exercise?



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