What is the average Year Named, when Latitude is 37.9N, and when Diameter (km) is greater than 76?
CREATE TABLE table_name_70 (year_named INTEGER, latitude VARCHAR, diameter__km_ VARCHAR)
SELECT AVG(year_named) FROM table_name_70 WHERE latitude = "37.9n" AND diameter__km_ > 76
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_70 (year_named INTEGER, latitude VARCHAR, diameter__km_ VARCHAR) Question: What is the average Year Named, when Latitude is 37.9N, and when Diameter (km) is greater than 76? [/INST] SELECT AVG(year_named) FROM table_name_70 WHERE latitude = "37.9n" AND diameter__km_ > 76 </s>