What is the average Games for 1965–1981, and a Ranking larger than 4?
CREATE TABLE table_name_52 (games INTEGER, years VARCHAR, ranking VARCHAR)
SELECT AVG(games) FROM table_name_52 WHERE years = "1965–1981" AND ranking > 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_52 (games INTEGER, years VARCHAR, ranking VARCHAR) Question: What is the average Games for 1965–1981, and a Ranking larger than 4? [/INST] SELECT AVG(games) FROM table_name_52 WHERE years = "1965–1981" AND ranking > 4 </s>