Database: address_1
Question: Count the number of cities in Canada.
SQL:
SELECT count(*) FROM City WHERE country  =  "CANADA"