what is the number of provincial captial where the province is northern cape?
CREATE TABLE table_17416221_1 (provincial_capital VARCHAR, province VARCHAR)
SELECT COUNT(provincial_capital) FROM table_17416221_1 WHERE province = "Northern Cape"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_17416221_1 (provincial_capital VARCHAR, province VARCHAR) Question: what is the number of provincial captial where the province is northern cape? [/INST] SELECT COUNT(provincial_capital) FROM table_17416221_1 WHERE province = "Northern Cape" </s>