mysql_2

SELECT winner
  FROM nobel
 WHERE yr = 1962
   AND subject = 'Literature'

Correct answer

winner
John Steinbeck

SELECT winner
  FROM nobel
WHERE yr >= 2000 and subject = 'Peace'

Correct answer

winner
Tunisian National Dialogue Quartet
Kailash Satyarthi
Malala Yousafzai

 SELECT *
  FROM nobel
WHERE yr>=1980 AND yr<=1989 AND subject='Literature'

Correct answer

yr	subject	winner
1989	Literature	Camilo José Cela
1988	Literature	Naguib Mahfouz
1987	Literature	Joseph Brodsky
1986	Literature	Wole Soyinka

SELECT * FROM nobel
 WHERE winner IN ('Theodore Roosevelt',
                  'Woodrow Wilson',
                  'Jimmy Carter','Barack Obama')

Correct answer

yr	subject	winner
2009	Peace	Barack Obama
2002	Peace	Jimmy Carter
1919	Peace	Woodrow Wilson
1906	Peace	Theodore Roosevelt

 SELECT yr,subject,winner
  FROM nobel
WHERE subject='Physics' AND yr =1980 OR subject='Chemistry' AND yr =1984

Correct answer

yr	subject	winner
1984	Chemistry	Bruce Merrifield
1980	Physics	James Cronin
1980	Physics	Val Fitch

SELECT *
  FROM nobel
WHERE yr=1980 AND subject NOT IN ('Chemistry','Medicine')

Correct answer

yr	subject	winner
1980	Economics	Lawrence R. Klein
1980	Literature	Czeslaw Milosz
1980	Peace	Adolfo Pérez Esquivel
1980	Physics	James Cronin
1980	Physics	Val Fitch

 SELECT *
  FROM nobel
WHERE subject= 'Medicine' AND yr < 1910 OR subject= 'Literature' AND yr >= 2004

Correct answer

yr	subject	winner
2015	Literature	Svetlana Alexievich
2014	Literature	Patrick Modiano
2013	Literature	Alice Munro

SELECT *
  FROM nobel
WHERE winner='EUGENE O\'NEILL'

Correct answer

yr	subject	winner
1936	Literature	Eugene O'Neill

 SELECT winner,yr,subject
  FROM nobel
WHERE winner LIKE 'Sir%'
ORDER BY yr DESC,winner;

Correct answer

winner	yr	subject
Sir Martin J. Evans	2007	Medicine
Sir Peter Mansfield	2003	Medicine
Sir Paul Nurse	2001	Medicine
Sir Harold Kroto	1996	Chemistry

SELECT winner, subject
  FROM nobel
 WHERE yr=1984
 ORDER BY subject IN ('Physics','Chemistry') ASC,subject,winner

Correct answer

winner	subject
Richard Stone	Economics
Jaroslav Seifert	Literature
César Milstein	Medicine
Georges J.F. Köhler	Medicine

 https://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial