﻿ SQL - Display the Nobel prizes for 1970

# SQL Exercises: Display the Nobel prizes for 1970

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

From the following table, write a SQL query to find the Nobel Prize winner(s) for the year 1970. Return year, subject and winner.

Sample table : nobel_win

Sample Solution :

``````SELECT year,subject,winner
FROM nobel_win
WHERE year=1970;
``````

Output of the Query:

```year	subject		winner
1970	Physics		Hannes Alfven
1970	Physics		Louis Neel
1970	Chemistry	Luis Federico Leloir
1970	Physiology	Julius Axelrod
1970	Physiology	Ulf von Euler
1970	Physiology	Bernard Katz
1970	Literature	Aleksandr Solzhenitsyn
1970	Economics	Paul Samuelson
```

Code Explanation:

The above query in SQL that selects the "year", "subject" and "winner" columns from the 'nobel_win' table where the value of "year" column is 1970. The WHERE clause is used to filter the rows and only return the rows that match the condition specified in the WHERE clause.

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.

Previous SQL Exercise: Order which will be delivered by a specified salesman.
Next SQL Exercise: Who won the 1971 Nobel Prize for Literature?.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

﻿

## SQL: Tips of the Day

How to avoid the "divide by zero" error in SQL?

```Select Case when divisor=0 then null
Else dividend / divisor
End ,,,
```

OR:

```Select dividend / NULLIF(divisor, 0) ...
```

Ref: https://bit.ly/3dLj7gS

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook