What is the total number of positions having points over 2, more than 4 losses, and under 10 matches played?
CREATE TABLE table_name_20 (position VARCHAR, played VARCHAR, points VARCHAR, lost VARCHAR)
SELECT COUNT(position) FROM table_name_20 WHERE points > 2 AND lost > 4 AND played < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_20 (position VARCHAR, played VARCHAR, points VARCHAR, lost VARCHAR) Question: What is the total number of positions having points over 2, more than 4 losses, and under 10 matches played? [/INST] SELECT COUNT(position) FROM table_name_20 WHERE points > 2 AND lost > 4 AND played < 10 </s>