Name the total number of golden tickets being rosen shingle creek resort
CREATE TABLE table_22897967_1 (golden_tickets VARCHAR, callback_venue VARCHAR)
SELECT COUNT(golden_tickets) FROM table_22897967_1 WHERE callback_venue = "Rosen Shingle Creek Resort"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_22897967_1 (golden_tickets VARCHAR, callback_venue VARCHAR) Question: Name the total number of golden tickets being rosen shingle creek resort [/INST] SELECT COUNT(golden_tickets) FROM table_22897967_1 WHERE callback_venue = "Rosen Shingle Creek Resort" </s>