SELECT count(*) FROM city AS T1 JOIN country AS T2 ON T1.country_id  =  T2.country_id WHERE T2.country  =  'Australia'
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 '
select count ( * ) from city as t1 join country as t2 on t1 . country_id = t2 . country_id where t2 . country = value
How many cities are in Australia ?