Table: mcnish_race_stats
Columns: year
entrant
class
chassis
engine
rank
points

Question: Which class has a year prior to 2011 and audi r15 tdi as the chassis?
SQL: SELECT "class" FROM mcnish_race_stats WHERE "year" < 2011 AND "chassis" = 'audi r15 tdi'

Question: Which engine has a year later than 2006 and 60 as the points?
SQL: SELECT "engine" FROM mcnish_race_stats WHERE "year" > 2006 AND "points" = '60'

Question: How many years has an engine of audi 3.6l turbo v8 and 1st as the rank with an audi r8r as the chassis?
SQL: SELECT COUNT("year") FROM mcnish_race_stats WHERE "engine" = 'audi 3.6l turbo v8' AND "rank" = '1st' AND "chassis" = 'audi r8r'

Question: Which entrant has 25th as the rank?
SQL: SELECT "entrant" FROM mcnish_race_stats WHERE "rank" = '25th'