Quick Ref.
Functions
date
number
string
Data Types
date
number
string
nobel
yrsubjectwinner
1960ChemistryWillard F. Libby
1960LiteratureSaint-John Perse
1960MedicineSir Frank Macfarlane Burnet
1960MedicinePeter Medawar

nobel Nobel Laureates

We continue practicing simple SQL queries on a single table.

This tutorial is concerned with a table of Nobel prize winners: 

nobel(yr, subject, winner)

Exercises

Using the SELECT statement.

1a. Change the query shown so that it displays Nobel prizes for 1950.

Results
1b. Show who won the 1962 prize for Literature.

Results
2a. Show the year and subject that won 'Albert Einstein' his prize.

Results
2b. Give the name of the 'Peace' winners since the year 2000, including 2000.

Results
2c. Show all details (yr, subject, winner) of the Literature prize winners for 1980 to 1989 inclusive.

Results
2d. Show all details of the presidential winners: ('Theodore Roosevelt', 'Woodrow Wilson', 'Jed Bartlet', 'Jimmy Carter')

Results
2e. Show the winners with first name John

Results
3a. In which years was the Physics prize awarded but no Chemistry prize. (WARNING - this question is way too hard for this level, you will need to use sub queries or joins).

Results