Table: euroleague_2007_08_stats
Columns: rank
name
team
games
points

Question: What is the lowest number of games with a rank less than 1?
SQL: SELECT MIN("games") FROM euroleague_2007_08_stats WHERE "rank" < 1

Question: What is the name of the player with 305 points?
SQL: SELECT "name" FROM euroleague_2007_08_stats WHERE "points" = 305

Question: What is the total rank of team roanne, which has less than 14 games?
SQL: SELECT COUNT("rank") FROM euroleague_2007_08_stats WHERE "team" = 'roanne' AND "games" < 14