Table: player_stats_0809
Columns: player
position
league
copa_del_rey
champions_league
total

Question: What is the average Champions League assists for the players with League assists under 4?
SQL: SELECT AVG("champions_league") FROM player_stats_0809 WHERE "league" < 4

Question: What is the most Champions League assists for those with a total of 6 and position of Midfielder?
SQL: SELECT MAX("champions_league") FROM player_stats_0809 WHERE "total" = 6 AND "position" = 'midfielder'