which is the former pageant in the country where the new pageant is miss bahamas?
CREATE TABLE table_14308895_2 (former_pageant VARCHAR, new_pageant VARCHAR)
SELECT former_pageant FROM table_14308895_2 WHERE new_pageant = "Miss Bahamas"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_14308895_2 (former_pageant VARCHAR, new_pageant VARCHAR) Question: which is the former pageant in the country where the new pageant is miss bahamas? [/INST] SELECT former_pageant FROM table_14308895_2 WHERE new_pageant = "Miss Bahamas" </s>