Table: uefa_cup_stats
Columns: rank
name
team
goals
appearances

Question: Who had less than 7 goals, was ranked under 7, and had more than 8 appearances?
SQL: SELECT "name" FROM uefa_cup_stats WHERE "goals" < 7 AND "rank" < 7 AND "appearances" > 8

Question: What was the sum of ranks of those called Fernando Cavenaghi who appeared less than 7.
SQL: SELECT SUM("rank") FROM uefa_cup_stats WHERE "name" = 'fernando cavenaghi' AND "appearances" < 7

Question: How many appearances were made by people that had 5 goals and less than 7 rank?
SQL: SELECT COUNT("appearances") FROM uefa_cup_stats WHERE "goals" = 5 AND "rank" < 7