How many cities are in Australia?
SELECT count(*) FROM city AS T1 JOIN country AS T2 ON T1.country_id  =  T2.country_id WHERE T2.country  =  'Australia'
number of cities in Australia refers to COUNT(*) when country = 'Australia'; joining city table with country table on country_id to filter cities by country;