SELECT Quiz1

Some questions concerning basic SQL statements

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 produces this table

name	population
Bahrain	1234571
Swaziland	1220000
Timor-Leste	1066409

|type="()"}

-

FROM world SELECT name, population BETWEEN 1000000 AND 1250000

-

FROM name, population WHERE population BETWEEN 1000000 AND 1250000 SELECT world

+

SELECT name, population FROM world WHERE population BETWEEN 1000000 AND 1250000

-

SELECT population BETWEEN 1000000 AND 1250000 FROM world

-

WHERE population BETWEEN 1000000 AND 1250000 SELECT name, population FROM world

{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')