How many clubs have total medals less than 10?
CREATE TABLE club_rank (Total INTEGER)
SELECT COUNT(*) FROM club_rank WHERE Total < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE club_rank (Total INTEGER) Question: How many clubs have total medals less than 10? [/INST] SELECT COUNT(*) FROM club_rank WHERE Total < 10 </s>