Difference between revisions of "Nobel Quiz"

From SQLZOO
Jump to: navigation, search
Line 3: Line 3:
 
{Pick the code which shows the name of winner's names beginning with C and ending in n
 
{Pick the code which shows the name of winner's names beginning with C and ending in n
 
|type="()"}
 
|type="()"}
- SELECT name FROM nobel WHERE winner LIKE '%C%' AND winner LIKE '%n%'
+
-A. SELECT name FROM nobel WHERE winner LIKE '%C%' AND winner LIKE '%n%'
- SELECT name FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%'  
+
-B. SELECT name FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%'  
- SELECT name FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n'
+
-C. SELECT name FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n'
- SELECT winner FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%'
+
-D. SELECT winner FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%'
+ SELECT winner FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n'
+
+E. 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
 
{Select the code that shows how many Chemistry awards were given between 1950 and 1960
 
|type="()"}
 
|type="()"}
- SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND BETWEEN 1950 and 1960
+
-A. 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)
+
-B. 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
+
+C. 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
+
-D. 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)
+
-E. 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
 
{Pick the code that shows the amount of years where no Medicine awards were given
 
|type="()"}
 
|type="()"}
- SELECT COUNT(yr) FROM nobel WHERE subject NOT IN 'Medicine'
+
-A. SELECT COUNT(yr) FROM nobel WHERE subject NOT IN 'Medicine'
+ SELECT COUNT(yr) FROM nobel WHERE subject NOT LIKE 'Medicine'
+
+B. SELECT COUNT(yr) FROM nobel WHERE subject NOT LIKE 'Medicine'
- SELECT COUNT(yr) FROM nobel WHERE subject NOT 'Medicine'
+
-C. SELECT COUNT(yr) FROM nobel WHERE subject NOT 'Medicine'
- SELECT yr FROM nobel WHERE subject <> 'Medicine'
+
-D. SELECT yr FROM nobel WHERE subject <> 'Medicine'
- SELECT yr FROM nobel WHERE subject NOT LIKE 'Medicine'
+
-E. SELECT yr FROM nobel WHERE subject NOT LIKE 'Medicine'
  
 
{Select the code which would show the year when neither a Physics or Chemistry award was given
 
{Select the code which would show the year when neither a Physics or Chemistry award was given
 
|type="()"}
 
|type="()"}
- SELECT yr FROM nobel WHERE subject NOT IN(SELECT yr from nobel WHERE subject IN ('Chemistry','Physics'))
+
-A. 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'))
+
-B. 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'))
+
+C. 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'))
+
-D. 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'))
+
-E. 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
 
{Select the code which shows the years when a Medicine award was given but no Peace or Literature award was
 
|type="()"}
 
|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')
+
-A. 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')
+
-B. 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')
+
+C. 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')
+
-D. 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')
+
-E. 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')
 
</quiz>
 
</quiz>
  
 
[[Category:Quizzes]]
 
[[Category:Quizzes]]

Revision as of 10:54, 23 July 2012

Nobel Quiz <quiz shuffle=none display=simple> {Pick the code which shows the name of winner's names beginning with C and ending in n |type="()"} -A. SELECT name FROM nobel WHERE winner LIKE '%C%' AND winner LIKE '%n%' -B. SELECT name FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%' -C. SELECT name FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n' -D. SELECT winner FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%' +E. 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="()"} -A. SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND BETWEEN 1950 and 1960 -B. SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN (1950, 1960) +C. SELECT COUNT(subject) FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN 1950 and 1960 -D. SELECT subject FROM nobel WHERE subject = 'Chemistry' AND yr BETWEEN 1950 and 1960 -E. 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="()"} -A. SELECT COUNT(yr) FROM nobel WHERE subject NOT IN 'Medicine' +B. SELECT COUNT(yr) FROM nobel WHERE subject NOT LIKE 'Medicine' -C. SELECT COUNT(yr) FROM nobel WHERE subject NOT 'Medicine' -D. SELECT yr FROM nobel WHERE subject <> 'Medicine' -E. SELECT yr FROM nobel WHERE subject NOT LIKE 'Medicine'

{Select the code which would show the year when neither a Physics or Chemistry award was given |type="()"} -A. SELECT yr FROM nobel WHERE subject NOT IN(SELECT yr from nobel WHERE subject IN ('Chemistry','Physics')) -B. SELECT yr FROM nobel WHERE subject NOT IN(SELECT subject from nobel WHERE subject IN ('Chemistry','Physics')) +C. SELECT yr FROM nobel WHERE yr NOT IN(SELECT yr from nobel WHERE subject IN ('Chemistry','Physics')) -D. SELECT yr FROM nobel WHERE yr NOT IN(SELECT subject from nobel WHERE subject IN ('Chemistry','Physics')) -E. 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="()"} -A. 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') -B. SELECT DISTINCT yr FROM nobel WHERE subject='Medicine' and yr NOT IN(SELECT yr from nobel WHERE subject='Literature' AND subject='Peace') +C. 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') -D. SELECT DISTINCT yr FROM subject WHERE subject='Medicine' and yr NOT IN(SELECT yr from nobel WHERE subject='Literature' and subject='Peace') -E. 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') </quiz>