Fix the following SQLS to generate what each question is asking for.

Part $1$:

Show all details of the presidential winners:

Theodore Roosevelt

Thomas Woodrow Wilson

Jimmy Carter

Barack Obama

SELECT $*$ FROM nobel

WHERE $yr=1970$

AND subject IN $(\text{'}$Cookery$\text{'},$

'Chemistry',

'Literature'$)$

$\backslash$table$[[$yr$,$subject,winner$],[1920,$peace,L$$on Victor Auguste Bourgeois$]]$

Show what the answer should be$...$

$\backslash$table$[[yr,$subject,winner$],[1906,$peace,Theodore Roosevelt$],[1919,$peace,Thomas Woodrow Wilson$],[2002,$peace,Jimmy Carter$],[2009,$peace,Barack Obama$]]$

Show the winners with first name John

SELECT winner

FROM nobel

WHERE yr $2000$

AND subject $=$ 'peace'

Memorial,

Show what the answer should be$...$

$\backslash$table$[[$winner$],[$John James Rickard Macleod$],[$John Galsworthy$],[$John Howard Northrop$],[$John Raleigh Mott$],[$John Franklin Enders$],[$John Bardeen$]]$