use world;
select language from CountriesLanguages;
select language, country_code from CountriesLanguages;
show tables;
select distinct language from CountriesLanguages;
select distinct language, country_code from CountriesLanguages;
select name, population from Cities where country_code = 'FSM';
select name, population from Cities where country_code <> 'FSM';
select * from Cities where district in ('California', 'Washington', 'Oregon');
select name, population from Cities where population between 10000 and 20000;
select name from Countries where gnp > 1000000 and continent = 'Europe';
select name, gnp from Countries where gnp > 1000000 and continent = 'Europe' or continent = 'Asia';
select name, gnp from Countries where gnp > 1000000 and (continent = 'Europe' or continent = 'Asia');
select name, gnp from Countries where gnp > 1000000 and continent in ('Europe', 'Asia');
select name from Countries where name like '%state%';
select name, population from Countries order by population, name;
select name, population from Countries order by population desc, name;
select * from Cities where country_code = 'FRA' and population > 200000 order by population desc;
