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

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

Line 97:

Line 99:

</div>

</div>

+

==Literature in the 1980's==

<div class='qu'>

<div class='qu'>

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

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

Line 110:

Line 113:

</div>

</div>

+

==Only Presidents==

<div class='qu'>

<div class='qu'>

Show all details of the presidential winners:

Show all details of the presidential winners:

Line 115:

Line 119:

*Woodrow Wilson

*Woodrow Wilson

*Jimmy Carter

*Jimmy Carter

+

*Barack Obama

+

<source lang='sql' class='def'>

<source lang='sql' class='def'>

SELECT * FROM nobel

SELECT * FROM nobel

Line 125:

Line 131:

<source lang='sql' class='ans'>

<source lang='sql' class='ans'>

SELECT * FROM nobel

SELECT * FROM nobel

−

WHERE winner IN ('Theodore Roosevelt',

+

WHERE winner IN ('Theodore Roosevelt',

−

'Woodrow Wilson',

+

'Woodrow Wilson',

−

'Jed Bartlet',

+

'Jimmy Carter',

−

'Jimmy Carter')

+

'Barack Obama')

</source>

</source>

</div>

</div>

+

==John==

<div class='qu'>

<div class='qu'>

Show the winners with first name John

Show the winners with first name John

Line 143:

Line 150:

</div>

</div>

+

==Chemistry and Physics from different years==

<div class='qu'>

<div class='qu'>

−

<p class=imper>Show the Physics winners for 1980 together with the Chemistry winners for 1984.</p>

+

<p class=imper>Show the year, subject, and name of Physics winners for 1980 together with the Chemistry winners for 1984.</p>

<source lang='sql' class='def'>

<source lang='sql' class='def'>

</source>

</source>

Line 156:

Line 164:

</div>

</div>

+

==Exclude Chemists and Medics==

<div class='qu'>

<div class='qu'>

−

<p class=imper>Show the winners for 1980 excluding the Chemistry and Medicine</p>

+

<p class=imper>Show the year, subject, and name of winners for 1980 excluding Chemistry and Medicine</p>

<source lang='sql' class='def'>

<source lang='sql' class='def'>

</source>

</source>

Line 169:

Line 178:

</div>

</div>

+

==Early Medicine, Late Literature==

<div class='qu'>

<div class='qu'>

−

Show who won a 'Medicine' prize in an early year (before 1910, not including 1910) together with winners of a 'Literature' prize in a later year (after 2004, including 2004)

+

Show year, subject, and name of people who won a 'Medicine' prize in an early year (before 1910, not including 1910) together with winners of a 'Literature' prize in a later year (after 2004, including 2004)

<source lang='sql' class='def'>

<source lang='sql' class='def'>

</source>

</source>

Line 187:

Line 197:

==Harder Questions==

==Harder Questions==

+

==Umlaut==

<div class='qu'>

<div class='qu'>

−

Find all details of the prize won by PETER BRAUNBERG

+

Find all details of the prize won by PETER GRÜNBERG

−

<div class=hint title='Non-ASCII characters'>The u in his name has an '''umlaut''' - you should search for how to enter this character on your keyboard.</div>

+

<div class=hint title='Non-ASCII characters'>The u in his name has an '''umlaut'''. You may find this link useful https://en.wikipedia.org/wiki/%C3%9C#Keyboarding</div>

<source lang='sql' class='def'>

<source lang='sql' class='def'>

</source>

</source>

Line 200:

Line 211:

</div>

</div>

+

==Apostrophe==

<div class='qu'>

<div class='qu'>

Find all details of the prize won by EUGENE O'NEILL

Find all details of the prize won by EUGENE O'NEILL

Line 213:

Line 225:

</div>

</div>

+

==Knights of the realm==

<div class='qu'><span class='param respectorder'></span>

<div class='qu'><span class='param respectorder'></span>

Knights in order

Knights in order

Line 227:

Line 240:

</div>

</div>

+

==Chemistry and Physics last==

<div class='qu'><span class='param respectorder'></span>

<div class='qu'><span class='param respectorder'></span>

The expression '''subject IN ('Chemistry','Physics')''' can be used as a value - it will be '''0''' or '''1'''.

The expression '''subject IN ('Chemistry','Physics')''' can be used as a value - it will be '''0''' or '''1'''.

Chemistry and Physics from different years

Exclude Chemists and Medics

Show the year, subject, and name of winners for 1980 excluding Chemistry and Medicine

SELECT*FROMnobelWHEREyr=1980ANDsubjectNOTIN('Chemistry','Medicine')

Early Medicine, Late Literature

Show year, subject, and name of people who won a 'Medicine' prize in an early year (before 1910, not including 1910) together with winners of a 'Literature' prize in a later year (after 2004, including 2004)