How many appearances with fc igea virtus and 1 goal?
CREATE TABLE table_name_50 (appearances INTEGER, club VARCHAR, goals VARCHAR)
SELECT AVG(appearances) FROM table_name_50 WHERE club = "fc igea virtus" AND goals = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (appearances INTEGER, club VARCHAR, goals VARCHAR) Question: How many appearances with fc igea virtus and 1 goal? [/INST] SELECT AVG(appearances) FROM table_name_50 WHERE club = "fc igea virtus" AND goals = 1 </s>