Table: us_f2000_2010
Columns: rnd
circuit
location
date
pole_position
fastest_lap
most_laps_led
winning_driver
winning_team
supporting

Question: What location(s) did patrick mckenna lead the most laps?
SQL: SELECT "location" FROM us_f2000_2010 WHERE "most_laps_led" = 'Patrick McKenna'

Question: How many races went for 10 rounds?
SQL: SELECT COUNT("fastest_lap") FROM us_f2000_2010 WHERE "rnd" = '10'

Question: Who had the most laps led in monterey, california when scott rarick won the race?
SQL: SELECT "most_laps_led" FROM us_f2000_2010 WHERE "location" = 'Monterey, California' AND "winning_driver" = 'Scott Rarick'

Question: What was the winning team when mikhail goikhberg was the winning driver?
SQL: SELECT "winning_team" FROM us_f2000_2010 WHERE "winning_driver" = 'Mikhail Goikhberg'