CREATE TABLE country (country_id VARCHAR(255), country VARCHAR(255)); CREATE TABLE city (country_id VARCHAR(255))
How many cities are in Australia?
    
SQL: SELECT COUNT(*) FROM city AS T1 JOIN country AS T2 ON T1.country_id = T2.country_id WHERE T2.country = 'Australia'