Nobel Quiz

From SQLZOO
Revision as of 09:59, 7 August 2012 by Connor (Talk | contribs)

Jump to: navigation, search

Nobel Quiz

nobel
yr subject winner
1960 Chemistry Willard F. Libby
1960 Literature Saint-John Perse
1960 Medicine Sir Frank Macfarlane Burnet
1960 Medicine Peter Medawar
1960 Physics Donald A. Glaser
1960 Peace Albert Lutuli
...

<quiz shuffle=none display=simple> {Pick the code which shows the name of winner's names beginning with C and ending in n |type="()"} - SELECT name FROM nobel WHERE winner LIKE '%C%' AND winner LIKE '%n%' - SELECT name FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%' - SELECT name FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n' - SELECT winner FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%' + SELECT winner FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n'

{Select the code that shows how many Chemistry awards were given between 1950 and 1960 |type="()"} - SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND BETWEEN 1950 and 1960 - SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN (1950, 1960) + SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN 1950 and 1960 - SELECT subject FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN 1950 and 1960 - SELECT subject FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN (1950, 1960)

{Pick the code that shows the amount of years where no Medicine awards were given |type="()"} - SELECT COUNT(yr) FROM nobel WHERE subject NOT IN 'Medicine' + SELECT COUNT(yr) FROM nobel WHERE subject NOT LIKE 'Medicine' - SELECT COUNT(yr) FROM nobel WHERE subject NOT 'Medicine' - SELECT yr FROM nobel WHERE subject <> 'Medicine' - SELECT yr FROM nobel WHERE subject NOT LIKE 'Medicine'

{Select the result that would be obtained from the following code: SELECT subject, winner FROM nobel WHERE winner LIKE 'Sir%' AND yr LIKE '196%'

Table-A
MedicineJohn Eccles
MedicineFrank Macfarlane Burnet
Table-B
ChemistrySir Cyril Hinshelwood
Table-C
MedicineSir John Eccles
MedicineSir Frank Macfarlane Burnet
Table-D
MedicineJohn Eccles
MedicineFrank Macfarlane Burnet
ChemistryWillard F.Libby
Table-E
Sir John Eccles
Sir Frank Macfarlane Burnet

|type="()"} - Table-A - Table-B + Table-C - Table-D - Table-E

{Select the code which would show the year when neither a Physics or Chemistry award was given |type="()"} - SELECT yr FROM nobel WHERE subject NOT IN(SELECT yr from nobel WHERE subject IN ('Chemistry','Physics')) - SELECT yr FROM nobel WHERE subject NOT IN(SELECT subject from nobel WHERE subject IN ('Chemistry','Physics')) + SELECT yr FROM nobel WHERE yr NOT IN(SELECT yr from nobel WHERE subject IN ('Chemistry','Physics')) - SELECT yr FROM nobel WHERE yr NOT IN(SELECT subject from nobel WHERE subject IN ('Chemistry','Physics')) - SELECT yr FROM subject WHERE yr NOT IN(SELECT yr from nobel WHERE subject IN ('Chemistry','Physics'))

{Select the code which shows the years when a Medicine award was given but no Peace or Literature award was |type="()"} - SELECT DISTINCT yr FROM nobel WHERE subject='Medicine' and subject NOT IN(SELECT yr from nobel WHERE subject='Literature') and yr NOT IN (SELECT yr FROM nobel WHERE subject='Peace') - SELECT DISTINCT yr FROM nobel WHERE subject='Medicine' and yr NOT IN(SELECT yr from nobel WHERE subject='Literature' AND subject='Peace') + SELECT DISTINCT yr FROM nobel WHERE subject='Medicine' and yr NOT IN(SELECT yr from nobel WHERE subject='Literature') and yr NOT IN (SELECT yr FROM nobel WHERE subject='Peace') - SELECT DISTINCT yr FROM subject WHERE subject='Medicine' and yr NOT IN(SELECT yr from nobel WHERE subject='Literature' and subject='Peace') - SELECT DISTINCT yr FROM subject WHERE subject='Medicine' and yr NOT IN(SELECT yr from nobel WHERE subject='Literature') and yr NOT IN (SELECT yr FROM nobel WHERE subject='Peace')

{Pick the result that would be obtained from the following code: SELECT subject, COUNT(subject) FROM nobel WHERE yr ='1960' GROUP BY subject

Table-A
1
1
2
1
1
Table-B
Chemistry6
Table-C
Chemistry3
Literature1
Medicine2
Peace0
Physics2
Table-D
Chemistry1
Literature1
Medicine2
Peace1
Physics1
Table-E
Chemistry1
Literature1
Peace1
Physics1

|type="()"} - Table-A - Table-B - Table-C + Table-D - Table-E </quiz>