<table><caption>Table-E</caption><tr><td>France</td></tr><tr><td>Germany</td></tr><tr><td>Russia</td></tr><tr><td>Turkey</td></tr><tr><td>Brazil</td></tr><tr><td>United States of USA</td></tr><tr><td>Canada</td></tr></table>

|type="()"}

|type="()"}

−

-A. SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Africa' AND gdp=0)

+

- Table-A

−

+B. SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Africa' AND gdp IS NOT NULL)

+

- Table-B

−

-C. SELECT name FROM bbc WHERE gdp > ALL (SELECT MIN(gdp) FROM bbc WHERE region = 'Africa' AND gdp IS NOT NULL)

+

- Table-C

−

-D. SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Africa' AND population IS NOT NULL)

+

+ Table-D

−

-E. SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Europe' AND gdp IS NOT NULL)

+

- Table-E

+

+

{Select the code that would show the countries with a greater GDP than any country in Africa

+

|type="()"}

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Africa' AND gdp=0) </syntaxhighlight>

+

+ <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Africa' AND gdp IS NOT NULL) </syntaxhighlight>

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE gdp > ALL (SELECT MIN(gdp) FROM bbc WHERE region = 'Africa' AND gdp IS NOT NULL) </syntaxhighlight>

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Africa' AND population IS NOT NULL) </syntaxhighlight>

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = 'Europe' AND gdp IS NOT NULL) </syntaxhighlight>

{Select the code that shows the countries with population smaller than Russia but bigger than Denmark

{Select the code that shows the countries with population smaller than Russia but bigger than Denmark

|type="()"}

|type="()"}

−

-A. SELECT name FROM bbc WHERE population < (SELECT population FROM bbc WHERE name='Denmark') AND population > (SELECT population FROM bbc WHERE name='Russia')

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE population < (SELECT population FROM bbc WHERE name='Denmark') AND population > (SELECT population FROM bbc WHERE name='Russia') </syntaxhighlight>

−

+B. SELECT name FROM bbc WHERE population < (SELECT population FROM bbc WHERE name='Russia') AND population > (SELECT population FROM bbc WHERE name='Denmark')

+

+ <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE population < (SELECT population FROM bbc WHERE name='Russia') AND population > (SELECT population FROM bbc WHERE name='Denmark') </syntaxhighlight>

−

-C. SELECT name FROM bbc WHERE population = (SELECT population FROM bbc WHERE name='Russia') AND population > (SELECT population FROM bbc WHERE name='Denmark')

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE population = (SELECT population FROM bbc WHERE name='Russia') AND population > (SELECT population FROM bbc WHERE name='Denmark') </syntaxhighlight>

−

-D. SELECT name FROM bbc WHERE population > (SELECT population FROM bbc WHERE name='Russia') AND population > (SELECT population FROM bbc WHERE name='Denmark')

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE population > (SELECT population FROM bbc WHERE name='Russia') AND population > (SELECT population FROM bbc WHERE name='Denmark') </syntaxhighlight>

−

-E. SELECT name FROM bbc WHERE population < (SELECT population FROM bbc WHERE name='Russia' AND population > (SELECT population FROM bbc WHERE name='Denmark')

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE population < (SELECT population FROM bbc WHERE name='Russia' AND population > (SELECT population FROM bbc WHERE name='Denmark') </syntaxhighlight>

+

+

{Select the result that would be obtained from the following code: SELECT name FROM bbc WHERE population > ALL (SELECT MAX(population) FROM bbc WHERE region = 'Europe') AND region ='South Asia'

<quiz shuffle=none display=simple>
{Select the code that shows the name, region and population of the smallest country in each region
|type="()"}

-

SELECT region, name,FROM bbc x WHERE population <=ALL(SELECT population FROM bbc y WHERE y.region=x.region AND population>0)

-

SELECT region, name, population FROM bbc WHERE population <=ALL(SELECT population FROM bbc WHERE population>0)

+

SELECT region, name, population FROM bbc x WHERE population <=ALL(SELECT population FROM bbc y WHERE y.region=x.region AND population>0)

-

SELECT region, name, population FROM bbc x WHERE population =ALL(SELECT population FROM bbc y WHERE y.region=x.region AND population>0)

-

SELECT region, name, population FROM bbc x WHERE population <=ALL(SELECT population FROM bbc y WHERE y.region=x.region AND population<0)

{Select the code that shows the countries belonging to regions with all populations over 50000
|type="()"}

-

SELECT name,region,population FROM bbc x WHERE50000<=ALL(SELECT population FROM bbc y WHERE population>0)+<syntaxhighlight lang='sql'>SELECT name,region,population FROM bbc x WHERE50000<=ALL(SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)

-

SELECT name,region,population FROM bbc x WHERE50000=ALL(SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)

-

SELECT name,region,population FROM bbc x WHERE50000>=ALL(SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)

-

SELECT name,region,population FROM bbc x WHERE500000<=ALL(SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)

{Select the code that shows the countries with a third of the population of the countries around it
|type="()"}

SELECT name, region FROM bbc x WHERE population <ALL(SELECT population/3FROM bbc y WHERE y.name != x.name){SELECT the RESULT that would be obtained FROM the following code:
<SOURCE lang=sql>SELECT name FROM bbc
WHERE population >(SELECT population
FROM bbc
WHERE name='United Kingdom')AND region IN(SELECT region
FROM bbc
WHERE name ='United Kingdom')</source><table><caption>Table-A</caption><tr><td>Andorra</td></tr><tr><td>Albania</td></tr><tr><td>Austria</td></tr><tr><td>Bulgaria</td></tr></table><table><caption>Table-B</caption><tr><td>France</td><td>Europe</td></tr><tr><td>Germany</td><td>Europe</td></tr><tr><td>Russia</td><td>Europe</td></tr><tr><td>Turkey</td><td>Europe</td></tr></table><table><caption>Table-C</caption><tr><td>France</td></tr><tr><td>Germany</td></tr><tr><td>Andorra</td></tr><tr><td>Albania</td></tr></table><table><caption>Table-D</caption><tr><td>France</td></tr><tr><td>Germany</td></tr><tr><td>Russia</td></tr><tr><td>Turkey</td></tr></table><table><caption>Table-E</caption><tr><td>France</td></tr><tr><td>Germany</td></tr><tr><td>Russia</td></tr><tr><td>Turkey</td></tr><tr><td>Brazil</td></tr><tr><td>United States OF USA</td></tr><tr><td>Canada</td></tr></table>|TYPE="()"}- Table-A
- Table-B
- Table-C
+ Table-D
- Table-E
{SELECT the code that would SHOW the countries WITH a greater GDP than any country IN Africa
|TYPE="()"}-<syntaxhighlight lang='sql'>SELECT name FROM bbc WHERE gdp >ALL(SELECTMAX(gdp)FROM bbc WHERE region ='Africa'AND gdp=0)

+

SELECT name FROM bbc WHERE gdp >ALL(SELECTMAX(gdp)FROM bbc WHERE region ='Africa'AND gdp ISNOTNULL)

-

SELECT name FROM bbc WHERE gdp >ALL(SELECTMIN(gdp)FROM bbc WHERE region ='Africa'AND gdp ISNOTNULL)

-

SELECT name FROM bbc WHERE gdp >ALL(SELECTMAX(gdp)FROM bbc WHERE region ='Africa'AND population ISNOTNULL)

-

SELECT name FROM bbc WHERE gdp >ALL(SELECTMAX(gdp)FROM bbc WHERE region ='Europe'AND gdp ISNOTNULL)

{Select the code that shows the countries with population smaller than Russia but bigger than Denmark
|type="()"}

-

SELECT name FROM bbc WHERE population <(SELECT population FROM bbc WHERE name='Denmark')AND population >(SELECT population FROM bbc WHERE name='Russia')

+

SELECT name FROM bbc WHERE population <(SELECT population FROM bbc WHERE name='Russia')AND population >(SELECT population FROM bbc WHERE name='Denmark')

-

SELECT name FROM bbc WHERE population =(SELECT population FROM bbc WHERE name='Russia')AND population >(SELECT population FROM bbc WHERE name='Denmark')

-

SELECT name FROM bbc WHERE population >(SELECT population FROM bbc WHERE name='Russia')AND population >(SELECT population FROM bbc WHERE name='Denmark')

-

SELECT name FROM bbc WHERE population <(SELECT population FROM bbc WHERE name='Russia'AND population >(SELECT population FROM bbc WHERE name='Denmark')

{Select the result that would be obtained from the following code: SELECT name FROM bbc WHERE population > ALL (SELECT MAX(population) FROM bbc WHERE region = 'Europe') AND region ='South Asia'