Table: race_results_92
Columns: year
team
co_drivers
class
laps
pos
class_pos

Question: Name the most laps for corvette racing in 2004
SQL: SELECT MAX("laps") FROM race_results_92 WHERE "team" = 'corvette racing' AND "year" = 2004

Question: Name the class for 4th position with year before 2006
SQL: SELECT "class" FROM race_results_92 WHERE "pos" = '4th' AND "year" < 2006

Question: Name the total number of laps for 23rd position
SQL: SELECT COUNT("laps") FROM race_results_92 WHERE "pos" = '23rd'

Question: Name the team with laps less than 315 and co-drivers of david brabham franck lagorce?
SQL: SELECT "team" FROM race_results_92 WHERE "laps" < 315 AND "co_drivers" = 'david brabham franck lagorce'

Question: Name the team for co-drivers of david brabham mario andretti
SQL: SELECT "team" FROM race_results_92 WHERE "co_drivers" = 'david brabham mario andretti'