Table: olympic_pistol_scores
Columns: place
shooter
total
round_1
round_2
round_3
round_4
round_5
round_6

Question: Who shot an 80 in round 3
SQL: SELECT "shooter" FROM olympic_pistol_scores WHERE "round_3" = 80

Question: What is the highest score of round 1 where they also shot 90 in round 2
SQL: SELECT MAX("round_1") FROM olympic_pistol_scores WHERE "round_2" = 90