What is the average number of field goals scored by a right halfback who had more than 3 touchdowns?
CREATE TABLE table_name_80 (field_goals INTEGER, position VARCHAR, touchdowns VARCHAR)
SELECT AVG(field_goals) FROM table_name_80 WHERE position = "right halfback" AND touchdowns > 3
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_80 (field_goals INTEGER, position VARCHAR, touchdowns VARCHAR) Question: What is the average number of field goals scored by a right halfback who had more than 3 touchdowns? [/INST] SELECT AVG(field_goals) FROM table_name_80 WHERE position = "right halfback" AND touchdowns > 3 </s>