What 2012 amount of earnings corresponds with less than 28 tournaments played?
CREATE TABLE table_name_59 (earnings___$__ VARCHAR, tournaments_played VARCHAR, year VARCHAR)
SELECT earnings___$__ FROM table_name_59 WHERE tournaments_played < 28 AND year = "2012"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (earnings___$__ VARCHAR, tournaments_played VARCHAR, year VARCHAR) Question: What 2012 amount of earnings corresponds with less than 28 tournaments played? [/INST] SELECT earnings___$__ FROM table_name_59 WHERE tournaments_played < 28 AND year = "2012" </s>