Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM country WHERE country = "Australia"
Feedback: Find number of rows in city table whose country id's corresponding country's country equals Australia .
Output (English): SELECT count(*) FROM city AS T1 JOIN country AS T2 ON T1.country_id  =  T2.country_id WHERE T2.country  =  'Australia'