How many ranks have chen yin as the name, with a lane greater than 8?
CREATE TABLE table_name_22 (rank INTEGER, name VARCHAR, lane VARCHAR)
SELECT SUM(rank) FROM table_name_22 WHERE name = "chen yin" AND lane > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (rank INTEGER, name VARCHAR, lane VARCHAR) Question: How many ranks have chen yin as the name, with a lane greater than 8? [/INST] SELECT SUM(rank) FROM table_name_22 WHERE name = "chen yin" AND lane > 8 </s>