Table: huddersfield_2001_02_players
Columns: squad_no
name
position
league_apps
league_goals
fa_cup_apps
fa_cup_goals
league_cup_apps
league_cup_goals
flt_apps
flt_goals
playoff_apps
playoff_goals
total_apps
total_goals

Question: What was the playoff apps for Thomas Heary, that had the position df?
SQL: SELECT "playoff_apps" FROM huddersfield_2001_02_players WHERE "position" = 'df' AND "name" = 'thomas heary'

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

Question: How many total goals did the squad with 2 playoff apps, 2 FA Cup Apps, and 0 League Cup goals get?
SQL: SELECT SUM("total_goals") FROM huddersfield_2001_02_players WHERE "playoff_apps" = '2' AND "fa_cup_apps" = '2' AND "league_cup_goals" < 0