CREATE TABLE table_name_28 (squad_no INT, playoff_goals VARCHAR, total_goals VARCHAR, league_goals VARCHAR)

What's the lowest squad number with more than 6 goals, fewer than 8 league goals, and more than 0 playoff goals?
SELECT MIN(squad_no) FROM table_name_28 WHERE total_goals > 6 AND league_goals < 8 AND playoff_goals > 0
SELECT MIN("squad_no") FROM "table_name_28" WHERE "league_goals" < 8 AND "playoff_goals" > 0 AND "total_goals" > 6