Difference between revisions of "Nobel Quiz"

From SQLZOO
Jump to: navigation, search
(Created page with "Nobel Quiz <quiz shuffle=none display=simple> {Which of these shows the name of winner's names beginning with C and ending in n? |type="()"} - SELECT name FROM nobel WHERE win...")
 
Line 3: Line 3:
 
{Which of these shows the name of winner's names beginning with C and ending in n?
 
{Which of these shows the name of winner's names beginning with C and ending in n?
 
|type="()"}
 
|type="()"}
- SELECT name FROM nobel WHERE winner LIKE '%D%' AND winner LIKE '%n%'
+
- SELECT name FROM nobel WHERE winner LIKE '%C%' AND winner LIKE '%n%'
- SELECT name FROM nobel WHERE winner LIKE '%D' AND winner LIKE 'n%'  
+
- SELECT name FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%'  
- SELECT name FROM nobel WHERE winner LIKE 'D%' AND winner LIKE '%n'
+
- SELECT name FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n'
- SELECT winner FROM nobel WHERE winner LIKE '%D' AND winner LIKE 'n%'
+
- SELECT winner FROM nobel WHERE winner LIKE '%C' AND winner LIKE 'n%'
+ SELECT winner FROM nobel WHERE winner LIKE 'D%' AND winner LIKE '%n'
+
+ SELECT winner FROM nobel WHERE winner LIKE 'C%' AND winner LIKE '%n'
  
 
{Which of these shows how many Chemistry awards were given between 1950 and 1960?
 
{Which of these shows how many Chemistry awards were given between 1950 and 1960?

Revision as of 10:52, 18 July 2012

Nobel Quiz <quiz shuffle=none display=simple> {Which of these 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'

{Which of these 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)


{Which of these 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'

{Which of these 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'))

{Which of these 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') </quiz>