SQL World database

SQL World database

In deze les ga je oefenen met queries.

Hiervoor gebruik je de database World

1 / 13
next
Slide 1: Slide
New lesson editorICTMBOStudiejaar 3

This lesson contains 13 slides, with interactive quizzes and text slide.

Report this lesson

Items in this lesson

SQL World database

In deze les ga je oefenen met queries.

Hiervoor gebruik je de database World

Hier zie je een overzicht van de tabellen in de database World.


Wat zijn de primary keys in de tabellen city, country en countrylanguage?

A

city.ID, country.Code en countrylanguage.Language

B

city.Name, Country.Name en city.ID

C

city.countrycode, country.Name en countrylanguage.CountryCode

D

country.Language, city.Code en countrylanguage.District




Welke kolommen in de tabellen city en countrylanguage bevatten dezelfde informatie als de kolom country.Code?



A

Name en Language

B

Er zijn geen kolommen met dezelfde informatie.

C

City.ID en countrylanguage.CountryCode

D

city.CountryCode en countrylanguage.CountryCode

Vraag 1: Toon alles van alle landen

A

SHOW ALL FROM country;

B

SELECT country.* FROM world;

C

SELECT * FROM country;

D

SELECT * FROM countries;

Vraag 2:

Toon alle steden en hun inwonersaantallen van België

A

SELECT Name, Population FROM city WHERE CountryCode = 'BEL';

B

SELECT city.Name, country.Population FROM city JOIN country ON CountryCode = Code WHERE Name = 'Belgium';

C

SELECT Name, Population FROM city WHERE Name = 'Belgium';

D

SELECT * FROM city WHERE Country = 'Belgium';

3: Toon alle talen die gesproken worden in Nederland

A

SELECT Language FROM countrylanguage WHERE Name = 'Netherlands';

B

SELECT Language FROM countrylanguage JOIN country ON countrylanguage.CountryCode = country.Code WHERE country.Name = 'Netherlands';

C

select countrylanguage.Language from countrylanguage where countrylanguage.countrycode="NLD";

D

SELECT Language FROM country WHERE Name = 'Netherlands';

4: Toon de namen en continenten van de landen die meer dan 100 miljoen inwoners hebben

A

SELECT Name, Continent FROM country HAVING Population > 100000000;

B

SELECT Name, Continent FROM country WHERE Population >= 100000000;

C

SELECT Name, Continent FROM country WHERE Population > 100000000;

D

SELECT Name, Continent FROM country FILTER (Population > 100000000);

5: Toon de gemiddelde levensverwachting van Europa

A

SELECT AVERAGE(LifeExpectancy) FROM country WHERE Continent = 'Europe';

B

SELECT AVG(LifeExpectancy) FROM country WHERE Continent = 'Europe';

C

SELECT MEAN(LifeExpectancy) FROM country WHERE Continent = 'Europe';

D

SELECT SUM(LifeExpectancy) / COUNT(*) FROM country WHERE Continent = 'Europe';

6: Geef alle informatie terug van het land waarvoor de code ALB is

A

SELECT Code = 'ALB' FROM country;

B

SELECT * FROM country WHERE Code = 'ALB';

C

SELECT * FROM country WHERE Name = 'ALB';

D

FIND * FROM country WHERE Code = 'ALB';

7: Toon alles van alle steden

A

SHOW city;

B

SELECT * FROM city;

C

SELECT city.* FROM database;

D

GET * FROM city;

8: Toon de namen van alle landen die een stad met meer dan 10 miljoen inwoners hebben

A

SELECT country.Name FROM country JOIN city ON country.Code = city.CountryCode WHERE city.Population > 10000000;

B

SELECT Name FROM country WHERE Population > 10000000 JOIN city;

C

SELECT DISTINCT country.Name FROM country JOIN city ON country.Code = city.CountryCode WHERE city.Population > 10000000;

D

SELECT DISTINCT Name FROM country WHERE city.Population > 10000000;

9: Toon alle namen van landen in Afrika

A

SELECT Name FROM country WHERE Continent LIKE 'Africa';

B

SELECT Name FROM country WHERE Continent = 'Africa';

C

SELECT Continent FROM country WHERE Name = 'Africa';

D

SELECT * FROM country WHERE Continent = Africa;

10: Toon van alle plaatsen die beginnen met een Z de inwoners van de stad én die van het land (gescheiden door een pipe-symbool |) en noem dit "Aantallen"

A

SELECT city.Population + ' | ' + country.Population AS Aantallen FROM city JOIN country ON city.CountryCode = country.Code WHERE city.Name = 'Z%';

B

SELECT CONCAT(city.Population, country.Population) AS Aantallen FROM city JOIN country ON city.CountryCode = country.Code WHERE city.Name LIKE 'Z%';

C

SELECT city.Population, country.Population AS Aantallen FROM city JOIN country ON city.CountryCode = country.Code WHERE city.Name LIKE 'Z%';

D

SELECT CONCAT(city.Population, ' | ', country.Population) AS Aantallen FROM city JOIN country ON city.CountryCode = country.Code WHERE city.Name LIKE 'Z%';