Nobel Quiz

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(DISTINCT yr) FROM nobel WHERE yr IN (SELECT DISTINCT yr FROM nobel WHERE subject <> 'Medicine')

+

 SELECT COUNT(DISTINCT yr) FROM nobel WHERE yr NOT IN (SELECT DISTINCT yr FROM nobel WHERE subject = 'Medicine')

-

 SELECT DISTINCT yr FROM nobel WHERE yr NOT IN (SELECT DISTINCT yr FROM nobel WHERE subject LIKE 'Medicine')

-

 SELECT COUNT(DISTINCT yr) FROM nobel WHERE yr NOT IN (SELECT DISTINCT yr FROM nobel WHERE subject NOT LIKE 'Medicine')

-

 SELECT COUNT(yr) FROM nobel WHERE yr NOT IN (SELECT DISTINCT yr FROM nobel WHERE subject = '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

Medicine	John Eccles
Medicine	Frank Macfarlane Burnet

Table-B

Chemistry

Sir Cyril Hinshelwood

Table-C

Medicine	Sir John Eccles
Medicine	Sir Frank Macfarlane Burnet

Table-D

Medicine	John Eccles
Medicine	Frank Macfarlane Burnet
Chemistry	Willard 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

Chemistry

6

Table-C

Chemistry	3
Literature	1
Medicine	2
Peace	0
Physics	2

Table-D

Chemistry	1
Literature	1
Medicine	2
Peace	1
Physics	1

Table-E

Chemistry	1
Literature	1
Peace	1
Physics	1

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