Which Touchdowns have an Extra points smaller than 5, and a Player of clark, and Field goals larger than 0?
CREATE TABLE table_name_8 (touchdowns INTEGER, field_goals VARCHAR, extra_points VARCHAR, player VARCHAR)
SELECT AVG(touchdowns) FROM table_name_8 WHERE extra_points < 5 AND player = "clark" AND field_goals > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (touchdowns INTEGER, field_goals VARCHAR, extra_points VARCHAR, player VARCHAR) Question: Which Touchdowns have an Extra points smaller than 5, and a Player of clark, and Field goals larger than 0? [/INST] SELECT AVG(touchdowns) FROM table_name_8 WHERE extra_points < 5 AND player = "clark" AND field_goals > 0 </s>