Table: indycar_race
Columns: round
race
pole_position
fastest_lap
most_laps_led
driver
team
manufacturer
report

Question: Who manufactured the car driven by Will Power and Scott Dixon had the most laps?
SQL: SELECT "manufacturer" FROM indycar_race WHERE "driver" = 'Will Power' AND "most_laps_led" = 'Scott Dixon'

Question: Who had the pole position in Detroit?
SQL: SELECT "pole_position" FROM indycar_race WHERE "race" = 'Detroit'

Question: Who was the driver in round 4?
SQL: SELECT "driver" FROM indycar_race WHERE "round" = 4

Question: Who had the pole position in Milwaukee?
SQL: SELECT "pole_position" FROM indycar_race WHERE "race" = 'Milwaukee'

Question: Who was the driver in round 8?
SQL: SELECT "driver" FROM indycar_race WHERE "round" = 8

Question: What race did Simon Pagenaud have the most laps in?
SQL: SELECT "race" FROM indycar_race WHERE "most_laps_led" = 'Simon Pagenaud'