Date for less than 122 countries and a 47% rank?
CREATE TABLE table_name_60 (date VARCHAR, countries_surveyed VARCHAR, _percentage_rank VARCHAR)
SELECT date FROM table_name_60 WHERE countries_surveyed < 122 AND _percentage_rank = "47"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_60 (date VARCHAR, countries_surveyed VARCHAR, _percentage_rank VARCHAR) Question: Date for less than 122 countries and a 47% rank? [/INST] SELECT date FROM table_name_60 WHERE countries_surveyed < 122 AND _percentage_rank = "47" </s>