Table: modern_pentathlon_2007
Columns: col
athlete_noc
shooting
fencing
swimming
riding
running
total

Question: What's Luis Siri's shooting score?
SQL: SELECT "shooting" FROM modern_pentathlon_2007 WHERE "athlete_noc" = 'Luis Siri'

Question: What's Eduardo Salas' riding score?
SQL: SELECT "riding" FROM modern_pentathlon_2007 WHERE "athlete_noc" = 'Eduardo Salas'

Question: What's the number of the player with 68.46 (1144 pts) in riding?
SQL: SELECT MAX("col") FROM modern_pentathlon_2007 WHERE "riding" = '68.46 (1144 pts)'

Question: Who's the player with 2:05.63 (1296 pts) swimming score?
SQL: SELECT "athlete_noc" FROM modern_pentathlon_2007 WHERE "swimming" = '2:05.63 (1296 pts)'

Question: What's the fencing score of the player with 9:40.31 (1080 pts) in running?
SQL: SELECT "fencing" FROM modern_pentathlon_2007 WHERE "running" = '9:40.31 (1080 pts)'

Question: What's Eli Bremer's fencing score?
SQL: SELECT "fencing" FROM modern_pentathlon_2007 WHERE "athlete_noc" = 'Eli Bremer'