How many Drawn have a Lost smaller than 25, and a Goal Difference of +7, and a Played larger than 34?
CREATE TABLE table_name_4 (drawn VARCHAR, played VARCHAR, lost VARCHAR, goal_difference VARCHAR)
SELECT COUNT(drawn) FROM table_name_4 WHERE lost < 25 AND goal_difference = "+7" AND played > 34
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (drawn VARCHAR, played VARCHAR, lost VARCHAR, goal_difference VARCHAR) Question: How many Drawn have a Lost smaller than 25, and a Goal Difference of +7, and a Played larger than 34? [/INST] SELECT COUNT(drawn) FROM table_name_4 WHERE lost < 25 AND goal_difference = "+7" AND played > 34 </s>