Table: uefa_champions_league_stats_2
Columns: rank
name
team
goals
appearances
minutes_played

Question: What is the total Goals with a Rank smaller than 10, a Name of nicolas anelka, and Appearances larger than 9?
SQL: SELECT SUM("goals") FROM uefa_champions_league_stats_2 WHERE "rank" < 10 AND "name" = 'nicolas anelka' AND "appearances" > 9

Question: What is the total Goals with Rank larger than 10?
SQL: SELECT SUM("goals") FROM uefa_champions_league_stats_2 WHERE "rank" > 10

Question: What is the greatest Goals with a Name of samuel eto'o?
SQL: SELECT MAX("goals") FROM uefa_champions_league_stats_2 WHERE "name" = 'samuel eto''o'

Question: What Rank has a Team of roma?
SQL: SELECT "rank" FROM uefa_champions_league_stats_2 WHERE "team" = 'roma'