﻿ SQL: The winners of a 'Physiology' prize in an early year before 1971 are shown in conjunction with the winners of a 'Peace' prize in a later year following the 1974 - w3resource

# SQL: The winners of a 'Physiology' prize in an early year before 1971 are shown in conjunction with the winners of a 'Peace' prize in a later year following the 1974

## SQL Basic Select Statement: Exercise-21 with Solution.

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.

Sample table: nobel_win

Sample Solution:

``````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
```

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?

﻿