Table: player_stats_06_07
Columns: player
position
premier_league
fa_cup
league_cup
uefa_cup
total

Question: What is the total number of appearances in the premier league when there were 10 appearances at UEFA and less than 4 at league cup?
SQL: SELECT COUNT("premier_league") FROM player_stats_06_07 WHERE "uefa_cup" = 10 AND "league_cup" < 4

Question: What is the highest total number of appearances when there were less than 4 at the FA cup?
SQL: SELECT MAX("total") FROM player_stats_06_07 WHERE "fa_cup" < 4

Question: What player had less than 6 appearances at the FA cup, 33 at the premier league, and more than 5 at the UEFA cup?
SQL: SELECT "player" FROM player_stats_06_07 WHERE "fa_cup" < 6 AND "premier_league" = 33 AND "uefa_cup" > 5

Question: What is the sum of the appearances at the league cup for the defender who had less than 10 appearances at the UEFA cup?
SQL: SELECT SUM("league_cup") FROM player_stats_06_07 WHERE "position" = 'defender' AND "uefa_cup" < 10