Table: race_results_2007
Columns: driver
team
laps
time_retired
grid
points

Question: Which grid has a time/retired of +3.9 secs in less than 96 laps?
SQL: SELECT AVG("grid") FROM race_results_2007 WHERE "time_retired" = '+3.9 secs' AND "laps" < 96

Question: Which driver has 7 points for team Australia?
SQL: SELECT "driver" FROM race_results_2007 WHERE "points" = 7 AND "team" = 'team australia'

Question: What is the fewest number of laps for a Dale Coyne Racing team with a mechanical time/retired and fewer than 5 points?
SQL: SELECT MIN("laps") FROM race_results_2007 WHERE "team" = 'dale coyne racing' AND "time_retired" = 'mechanical' AND "points" < 5

Question: What is the highest points total scored by Dan Clarke in a grid higher than 10?
SQL: SELECT MAX("points") FROM race_results_2007 WHERE "driver" = 'dan clarke' AND "grid" > 10