Table: briscoe_race_stats
Columns: year
chassis
engine
start
finish
team

Question: What chassis has 2012 as the year?
SQL: SELECT "chassis" FROM briscoe_race_stats WHERE "year" = 2012

Question: What engine has a start less than 7, and 23 as a finish?
SQL: SELECT "engine" FROM briscoe_race_stats WHERE "start" < 7 AND "finish" = 23

Question: What is the average finish that has a start greater than 3, with honda as the engine, and 2011 as the year?
SQL: SELECT AVG("finish") FROM briscoe_race_stats WHERE "start" > 3 AND "engine" = 'honda' AND "year" = 2011

Question: How many starts have a year prior to 2012, and team penske as the team, with a finish greater than 27?
SQL: SELECT SUM("start") FROM briscoe_race_stats WHERE "year" < 2012 AND "team" = 'team penske' AND "finish" > 27

Question: What start has a year later than 2010, and chip ganassi racing as the team?
SQL: SELECT "start" FROM briscoe_race_stats WHERE "year" > 2010 AND "team" = 'chip ganassi racing'