Table: uefa_champions_league_stats
Columns: rank
name
team
goals
appearances
minutes_played

Question: How many apperances for shakhtar donetsk?
SQL: SELECT COUNT("appearances") FROM uefa_champions_league_stats WHERE "team" = 'shakhtar donetsk'

Question: How many appearances for psv eindhoven ranked above 11?
SQL: SELECT SUM("appearances") FROM uefa_champions_league_stats WHERE "team" = 'psv eindhoven' AND "rank" < 11