SQL

Question 1

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for United States is USA.

The CITY table is described as follows:

LINK

Answer 1

SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION >= 100000;

Question 2

Query NAME column for all Canadian cities in the CITY table with populations larger than 100000. The CountryCode for Canada is CA.

The CITY table is described as follows:

LINK

Answer 2

SELECT NAME FROM CITY WHERE COUNTRYCODE= 'CA' AND POPULATION>=100000 ORDER BY CITY ASC;