SELECT Quiz

SELECT quiz

name	region	area	population	gdp
Afghanistan	South Asia	652225	26000000
Albania	Europe	28728	3200000	6656000000
Algeria	Middle East	2400000	32900000	75012000000
Andorra	Europe	468	64000
...

<quiz shuffle=none display=simple> {Select the code which shows the countries with a population between 100000000 and 200000000 |type="()"}

-

 SELECT name, population FROM bbc WHERE area BETWEEN 100000000 AND 200000000

-

 SELECT name, population FROM bbc WHERE population BETWEEN (100000000, 200000000)

+

 SELECT name, population FROM bbc WHERE population BETWEEN 100000000 AND 200000000

-

 SELECT name, population FROM bbc WHERE population BETWEEN 100000000, 200000000

-

 SELECT population FROM bbc WHERE population BETWEEN 100000000 AND 200000000

{Pick the result you would obtain from this code:

SELECT name, population
  FROM bbc 
 WHERE name LIKE "Al%"

Table-A

Albania

Algeria

Table-B

%bania	3200000
%geria	32900000

Table-C

Al

0

Table-D

Albania

3200000

Table-E

Albania	3200000
Algeria	32900000

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

{Select the code which shows the countries that end in A or L |type="()"}

-

 SELECT name FROM bbc WHERE name LIKE 'a%' AND name LIKE 'l%'

-

 SELECT name FROM bbc WHERE name LIKE 'a%' OR name LIKE 'l%'

-

 SELECT name FROM bbc WHERE name LIKE '%a' AND name LIKE '%l'

-

 SELECT name FROM bbc WHERE name LIKE '%a' OR 'l%'

+

 SELECT name FROM bbc WHERE name LIKE '%a' OR name LIKE '%l'

{Pick the result from the query

 SELECT name,length(name)
   FROM world
  WHERE length(name)=5 and continent='Europe'

Table-A

name	length(name)
Benin	5
Lybia	5
Egypt	5

Table-B

name	length(name)
Italy	5
Egypt	5
Spain	5

Table-C

name	length(name)
Italy	5
Malta	5
Spain	5

Table-D

name	length(name)
Italy	5
France	6
Spain	5

Table-E

name	length(name)
Sweden	6
Norway	6
Poland	6

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

{Pick the result you would obtain from this code:

SELECT name, area * 2 FROM bbc WHERE population = 64000

Table-A

Andorra

234

Table-B

Andorra

468

Table-C

Andorra

936

Table-D

Andorra

4680

Table-E

Andorra	936
Albania	57456

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

{Select the code that would show the countries with an area larger than 50000 and a population smaller than 10000000 |type="()"}

-

 SELECT name, area, population FROM bbc WHERE area < 50000 AND population < 10000000

-

 SELECT name, area, population FROM bbc WHERE area < 50000 AND population > 10000000

+

 SELECT name, area, population FROM bbc WHERE area > 50000 AND population < 10000000

-

 SELECT name, area, population FROM bbc WHERE area > 50000 AND population > 10000000

-

 SELECT name, area, population FROM bbc WHERE area = 50000 AND population = 10000000

{Select the code that shows the population density of China, Australia, Nigeria and France |type="()"}

-

 SELECT name, area/population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia')

-

 SELECT name, area/population FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')

+

 SELECT name, population/area FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia')

-

 SELECT name, population/area FROM bbc WHERE name LIKE ('China', 'Nigeria', 'France', 'Australia')

-

 SELECT name, population FROM bbc WHERE name IN ('China', 'Nigeria', 'France', 'Australia')

{Pick the result that would be obtained from this code: SELECT CONCAT(name,region), population FROM bbc WHERE region IN ('Africa','Middle East') AND name LIKE 'A%'

Table-A

(Algeria, Middle East)	32900000
(Angola, Africa)	14500000

Table-B

Algeria	32900000
Angola	14500000

Table-C

AlgeriaMiddle East	32900000
AngolaAfrica	14500000

Table-D

AngolaAfrica

14500000

Table-E

Algeria	Middle East
Angola	Africa

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

</quiz>