What is the highest yards for a rating larger than 52.8 and more than 13 games?
CREATE TABLE table_name_47 (yards INTEGER, rating VARCHAR, games VARCHAR)
SELECT MAX(yards) FROM table_name_47 WHERE rating > 52.8 AND games > 13
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (yards INTEGER, rating VARCHAR, games VARCHAR) Question: What is the highest yards for a rating larger than 52.8 and more than 13 games? [/INST] SELECT MAX(yards) FROM table_name_47 WHERE rating > 52.8 AND games > 13 </s>