How many tickets were sold and how many were available for the shows that grossed $348,674?
CREATE TABLE table_name_30 (ticket_sold___available VARCHAR, ticket_grossing VARCHAR)
SELECT ticket_sold___available FROM table_name_30 WHERE ticket_grossing = "$348,674"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (ticket_sold___available VARCHAR, ticket_grossing VARCHAR) Question: How many tickets were sold and how many were available for the shows that grossed $348,674? [/INST] SELECT ticket_sold___available FROM table_name_30 WHERE ticket_grossing = "$348,674" </s>