# Difference between revisions of "SELECT Quiz"

Jump to: navigation, search

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%"
```
 Albania Algeria
 %bania 3200000 %geria 32900000
 Al 0
 Albania 3200000
 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
namelength(name)
Benin5
Lybia5
Egypt5
Table-B
namelength(name)
Italy5
Egypt5
Spain5
Table-C
namelength(name)
Italy5
Malta5
Spain5
Table-D
namelength(name)
Italy5
France6
Spain5
Table-E
namelength(name)
Sweden6
Norway6
Poland6

|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
```
 Andorra 234
 Andorra 468
 Andorra 936
 Andorra 4680
 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%'

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

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

</quiz>