Basic SQL Your-Turn Solutions

YOUR TURN #1

select country, population
from Countries
where coastline = 'no' and population > 9
order by population desc

YOUR TURN #2

select city, Cities.country, latitude, EU
from Cities, Countries
where Cities.country = Countries.country
and latitude > 45 and coastline = 'no' and population > 9

YOUR TURN #3

select count(), min(latitude), max(latitude)
from Cities, Countries
where Cities.country = Countries.country
and latitude > 45 and coastline = 'no' and population > 9

YOUR TURN #4

select Cities.country, max(latitude)
from Cities, Countries
where Cities.country = Countries.country
and EU = 'yes'
group by Cities.country
order by max(latitude) desc

YOUR TURN #5

select city, Cities.country
from Cities, Countries
where Cities.country = Countries.country
and coastline = 'no'
order by longitude desc
limit 5