Which Fighting Spirit has a Name of tsurugamine, and a Technique smaller than 10?
CREATE TABLE table_name_55 (fighting_spirit INTEGER, name VARCHAR, technique VARCHAR)
SELECT AVG(fighting_spirit) FROM table_name_55 WHERE name = "tsurugamine" AND technique < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (fighting_spirit INTEGER, name VARCHAR, technique VARCHAR) Question: Which Fighting Spirit has a Name of tsurugamine, and a Technique smaller than 10? [/INST] SELECT AVG(fighting_spirit) FROM table_name_55 WHERE name = "tsurugamine" AND technique < 10 </s>