What's the lowest squad number with more than 6 goals, fewer than 8 league goals, and more than 0 playoff goals?
CREATE TABLE table_name_28 (squad_no INTEGER, playoff_goals VARCHAR, total_goals VARCHAR, league_goals VARCHAR)
SELECT MIN(squad_no) FROM table_name_28 WHERE total_goals > 6 AND league_goals < 8 AND playoff_goals > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_28 (squad_no INTEGER, playoff_goals VARCHAR, total_goals VARCHAR, league_goals VARCHAR) Question: What's the lowest squad number with more than 6 goals, fewer than 8 league goals, and more than 0 playoff goals? [/INST] SELECT MIN(squad_no) FROM table_name_28 WHERE total_goals > 6 AND league_goals < 8 AND playoff_goals > 0 </s>