How many games were lost where the win percentage is smaller than 16.7 and the played games is 3?
CREATE TABLE table_name_83 (lost VARCHAR, win__percentage VARCHAR, played VARCHAR)
SELECT COUNT(lost) FROM table_name_83 WHERE win__percentage < 16.7 AND played = 3
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_83 (lost VARCHAR, win__percentage VARCHAR, played VARCHAR) Question: How many games were lost where the win percentage is smaller than 16.7 and the played games is 3? [/INST] SELECT COUNT(lost) FROM table_name_83 WHERE win__percentage < 16.7 AND played = 3 </s>