Table: chess_2008_ratings_2
Columns: rank
prev
player
rating
chng

Question: What player has a rating greater than 2746, with a prev less than 4, and +4 as the chng?
SQL: SELECT "player" FROM chess_2008_ratings_2 WHERE "rating" > 2746 AND "prev" < 4 AND "chng" = '+4'

Question: What chng has a rank greater than 6, with 12 as a prev?
SQL: SELECT "chng" FROM chess_2008_ratings_2 WHERE "rank" > 6 AND "prev" = 12

Question: What is the highest prev that has 9 as the rank, with a rating less than 2746?
SQL: SELECT MAX("prev") FROM chess_2008_ratings_2 WHERE "rank" = 9 AND "rating" < 2746