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

# 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:

## Query Visualization:

Duration:

Rows:

Cost:

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

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

﻿