Table: victoriano_stats
Columns: rank
name
team
games
points

Question: How many Games has a Name of stéphane dumas and a Rank larger than 5?
SQL: SELECT AVG("games") FROM victoriano_stats WHERE "name" = 'stéphane dumas' AND "rank" > 5

Question: How many Games has a Team of cai zaragoza and a Rank smaller than 1?
SQL: SELECT SUM("games") FROM victoriano_stats WHERE "team" = 'cai zaragoza' AND "rank" < 1