2.复习 列出所有在Chicago
西部的城市,从西到东排序(包括所有字段)
select *
from North_american_cities
where longitude<-88
order by longitude
3.【复习】用人口数population
排序,列出墨西哥Mexico
最大的2个城市(包括所有字段)
select *
from North_american_cities
where country = "Mexico"
order by population desc
limit 2
4.【复习】列出美国United States
人口3-4位的两个城市和他们的人口(包括所有字段)
select *
from North_american_cities
where country = "United States"
order by population desc
limit 2 offset 2