What is the number of played games a club with more than 71 points and less than 8 losses has?
CREATE TABLE table_name_50 (played INTEGER, points VARCHAR, losses VARCHAR)
SELECT SUM(played) FROM table_name_50 WHERE points > 71 AND losses < 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (played INTEGER, points VARCHAR, losses VARCHAR) Question: What is the number of played games a club with more than 71 points and less than 8 losses has? [/INST] SELECT SUM(played) FROM table_name_50 WHERE points > 71 AND losses < 8 </s>