Table: serie_a_2008
Columns: rank
name
point
played
draw
lose
goal_in
goal_loss
goal_diff

Question: What was the average rank of a player with more than 52 points, fewer than 10 draws, a goal loss under 44, and a loss under 15?
SQL: SELECT AVG("rank") FROM serie_a_2008 WHERE "point" > 52 AND "draw" < 10 AND "goal_loss" < 44 AND "lose" < 15

Question: What was the highest number of lose for a player named Santos with more than 45 points?
SQL: SELECT MAX("lose") FROM serie_a_2008 WHERE "name" = 'santos' AND "point" > 45