Table: anand_kramnik_games
Columns: white
black
year
result
moves
tournament
opening

Question: What's the result when there's more than 41 moves with an opening of c42 petrov's defence in 2007?
SQL: SELECT "result" FROM anand_kramnik_games WHERE "moves" > 41 AND "year" = 2007 AND "opening" = 'c42 petrov''s defence'

Question: What's the total number of moves with a result of  ½–½ and a black of Anand before 1999?
SQL: SELECT COUNT("moves") FROM anand_kramnik_games WHERE "result" = '½–½' AND "year" < 1999 AND "black" = 'anand'

Question: What's the black with 24 moves in the dortmund tournament?
SQL: SELECT "black" FROM anand_kramnik_games WHERE "moves" = 24 AND "tournament" = 'dortmund'

Question: What's the opening when white is Anand with fewer than 61 moves for a result of  ½–½?
SQL: SELECT "opening" FROM anand_kramnik_games WHERE "white" = 'anand' AND "moves" < 61 AND "result" = '½–½'

Question: What's the white for a black of Anand, a result of  ½–½, 39 moves, and an opening of d37 queen's gambit declined?
SQL: SELECT "white" FROM anand_kramnik_games WHERE "black" = 'anand' AND "result" = '½–½' AND "moves" = 39 AND "opening" = 'd37 queen''s gambit declined'