How many League cups had a total less than 25 and a league larger than 19?
CREATE TABLE table_name_70 (league VARCHAR, total VARCHAR)
SELECT COUNT(league) AS Cup FROM table_name_70 WHERE total < 25 AND league > 19
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_70 (league VARCHAR, total VARCHAR) Question: How many League cups had a total less than 25 and a league larger than 19? [/INST] SELECT COUNT(league) AS Cup FROM table_name_70 WHERE total < 25 AND league > 19 </s>