What is teh average rank of the city of mashhad, which had less than 667770 in 1976?
CREATE TABLE table_name_97 (rank INTEGER, city VARCHAR)
SELECT AVG(rank) FROM table_name_97 WHERE city = "mashhad" AND 1976 < 667770
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (rank INTEGER, city VARCHAR) Question: What is teh average rank of the city of mashhad, which had less than 667770 in 1976? [/INST] SELECT AVG(rank) FROM table_name_97 WHERE city = "mashhad" AND 1976 < 667770 </s>