Quick Ref.
Functions
date
number
string
Data Types
date
number
string

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