Which Loera has a Source of surveyusa, and a Date of may 16–may 18, 2008?
CREATE TABLE table_name_47 (loera VARCHAR, source VARCHAR, date VARCHAR)
SELECT loera FROM table_name_47 WHERE source = "surveyusa" AND date = "may 16–may 18, 2008"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (loera VARCHAR, source VARCHAR, date VARCHAR) Question: Which Loera has a Source of surveyusa, and a Date of may 16–may 18, 2008? [/INST] SELECT loera FROM table_name_47 WHERE source = "surveyusa" AND date = "may 16–may 18, 2008" </s>