What points awarded are higher than 6 but smaller than 9
CREATE TABLE table_name_51 (points_awarded__platinum_ INTEGER, points_awarded__gold_ VARCHAR, points_awarded__silver_ VARCHAR)
SELECT MAX(points_awarded__platinum_) FROM table_name_51 WHERE points_awarded__gold_ = 9 AND points_awarded__silver_ > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_51 (points_awarded__platinum_ INTEGER, points_awarded__gold_ VARCHAR, points_awarded__silver_ VARCHAR) Question: What points awarded are higher than 6 but smaller than 9 [/INST] SELECT MAX(points_awarded__platinum_) FROM table_name_51 WHERE points_awarded__gold_ = 9 AND points_awarded__silver_ > 6 </s>