How many percentages have losses fewer than 1 with finals appearances of 4?
CREATE TABLE table_name_13 (pct VARCHAR, losses VARCHAR, finals VARCHAR)
SELECT COUNT(pct) FROM table_name_13 WHERE losses < 1 AND finals = 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_13 (pct VARCHAR, losses VARCHAR, finals VARCHAR) Question: How many percentages have losses fewer than 1 with finals appearances of 4? [/INST] SELECT COUNT(pct) FROM table_name_13 WHERE losses < 1 AND finals = 4 </s>