How many snatches were there with a total of 267.5?
CREATE TABLE table_name_73 (snatch VARCHAR, total INTEGER)
SELECT COUNT(snatch) FROM table_name_73 WHERE total < 267.5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_73 (snatch VARCHAR, total INTEGER) Question: How many snatches were there with a total of 267.5? [/INST] SELECT COUNT(snatch) FROM table_name_73 WHERE total < 267.5 </s>