Table: wrc_2010_stats
Columns: constructor
chassis
starts
finishes
wins
podiums
stage_wins
points

Question: what is the highest finishes when the points is less than 337, the stage wins is 2 and the wins is more than 0?
SQL: SELECT MAX("finishes") FROM wrc_2010_stats WHERE "points" < 337 AND "stage_wins" = 2 AND "wins" > 0

Question: what is the average starts when the chassis is focus rs wrc 08 and finishes is more than 27?
SQL: SELECT AVG("starts") FROM wrc_2010_stats WHERE "chassis" = 'focus rs wrc 08' AND "finishes" > 27

Question: what is the finishes when points is more than 337 and starts is more than 26?
SQL: SELECT SUM("finishes") FROM wrc_2010_stats WHERE "points" > 337 AND "starts" > 26

Question: what is the average starts when the podiums is more than 0, stage wins is more than 39 and points is more than 456?
SQL: SELECT AVG("starts") FROM wrc_2010_stats WHERE "podiums" > 0 AND "stage_wins" > 39 AND "points" > 456