1.【复习】列出所有加拿大人的Canadian信息(包括所有字段)
SELECT * FROM north_american_cities WHERE Country='Canada';
2.【复习】列出所有在Chicago西部的城市,从西到东排序(包括所有字段)
SELECT * FROM north_american_cities WHERE Longitude<'-87.629798' ORDER BY Longitude ASC;
SELECT * FROM north_american_cities WHERE Country='Canada';
SELECT * FROM north_american_cities WHERE Longitude<'-87.629798' ORDER BY Longitude ASC;