How many new pageants does Aruba have?
CREATE TABLE table_14308895_2 (new_pageant VARCHAR, country_territory VARCHAR)
SELECT COUNT(new_pageant) FROM table_14308895_2 WHERE country_territory = "Aruba"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_14308895_2 (new_pageant VARCHAR, country_territory VARCHAR) Question: How many new pageants does Aruba have? [/INST] SELECT COUNT(new_pageant) FROM table_14308895_2 WHERE country_territory = "Aruba" </s>