The purpose of this database is to facilitate the management and exploration of tourist attractions, events, cities, and countries, primarily focusing on Belgium and the Netherlands. It aims to provide users with information about attractions and events in these countries, allowing them to make informed decisions about places to visit.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 1. What are the names of countries with population greater than 8 million? | |
SELECT Name | |
FROM country | |
WHERE Population > 8000000; | |
-- 2. What are the names of countries that have “land” in their names? | |
SELECT name from city where name like "%land"; | |
-- 3. What are the names of the cities with population in between 500,000 and 1 million? | |
SELECT name from city where Population > 500000 and Population < 1000000; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 1. What are the names of countries with population greater than 8 million? | |
SELECT Name | |
FROM country | |
WHERE Population > 8000000; | |
-- 2. What are the names of countries that have “land” in their names? | |
SELECT name from city where name like "%land"; | |
-- 3. What are the names of the cities with population in between 500,000 and 1 million? | |
SELECT name from city where Population > 500000 and Population < 1000000; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select name from city where Population > 8000000; | |
select name from city where name like "%land"; | |
select name from city where Population > 500000 and Population < 1000000; | |
select name from country where Continent = "Europe"; | |
select name from city where CountryCode = 'nld'; | |
select Population from city where name = 'rotterdam'; | |
select * from country where HeadOfState is null; | |
select name, population from city limit 10; | |
select * from country where name = LocalName and Continent = 'Africa'; | |
select country.name from country join countrylanguage on country.code = countrylanguage.CountryCode where countrylanguage.`Language` = 'Spanish'; |