Resolver queries básicos - SQL

Base de datos: https://dev.mysql.com/doc/index-other.html

Queries del video:

-- 1. List the names of all the cities.
select name from city;

-- 2. List the names of all the cities sorted in descending order.
select name from city order by name desc;

-- 3. List the names of unique cities.
select distinct name from city limit 100000;

-- 4. List the names of all cities in Canada (code of CAN).
select name from city where countryCode = 'CAN' order by name asc;

-- 5. List the names of all cities in Ontario sorted in ascending order.
select name from city where district = 'Ontario' order by name asc;

-- 6. Calculate the total population of Argentina's cities (code ARG).
select sum( population ) as poblacion_argentina from city where countryCode = 'ARG';

-- 7. Calculate the number of Belgian cities stored in the table (code BEL).
select count(*) as ciudades_belgian from city where countryCode = 'BEL';

-- 8. List unique districts in Brazil (code BRA).
select distinct district from city where countryCode = 'BRA' order by district asc;

-- 9. Calculate the average population of the cities of Brazil (code BRA).
select AVG( population ) as promedio_ciudad_BRA from city where CountryCode = 'BRA';

-- 10. Calculate the number of records stored in the city table.
select count(*) as total_ciudades from city limit 100000;