What is the number of years that the event was foil team and took place in Los Angeles?
CREATE TABLE table_name_77 (year VARCHAR, venue VARCHAR, event VARCHAR)
SELECT COUNT(year) FROM table_name_77 WHERE venue = "los angeles" AND event = "foil team"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_77 (year VARCHAR, venue VARCHAR, event VARCHAR) Question: What is the number of years that the event was foil team and took place in Los Angeles? [/INST] SELECT COUNT(year) FROM table_name_77 WHERE venue = "los angeles" AND event = "foil team" </s>