1. Create a query that displays Nobel prizes for 1950 SELECT * FROM nobel WHERE yr = 1950 2. Show who won the 1962 prize for Literature SELECT winner FROM nobel WHERE yr = 1962 AND subject = 'Literature' 3. Show the year and subject that won 'Albert Einstein his prize SELECT yr, subject FROM nobel WHERE winner = 'Albert Einstein' 4. Give the name of the 'Peace' winners since the year 2000, inclu..

1. The example uses a WHERE clause to show the population of 'France'. Note that strings (pieces of text that are data) should be in 'single quotes'; Modify it to show the population of Germany SELECT population FROM world WHERE name = 'Germany' 2. Checking a list The word IN allows us to check if an item is in a list. Show the name and the population for 'Sweden', 'Norway' and 'Denmark'. SELECT..