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'