How many capital cities does Australia have?
CREATE TABLE table_1008653_1 (capital___endonym__ VARCHAR, country___endonym__ VARCHAR)
SELECT COUNT(capital___endonym__) FROM table_1008653_1 WHERE country___endonym__ = "Australia"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1008653_1 (capital___endonym__ VARCHAR, country___endonym__ VARCHAR) Question: How many capital cities does Australia have? [/INST] SELECT COUNT(capital___endonym__) FROM table_1008653_1 WHERE country___endonym__ = "Australia" </s>