Table: iannone_stats
Columns: season
races
podiums
pole
flaps

Question: WHAT IS THE FLAPS WITH PODIUMS OF 24 AND RACES BIGGER THAN 143?
SQL: SELECT MAX("flaps") FROM iannone_stats WHERE "podiums" = 24 AND "races" > 143

Question: WHAT ARE THE RACES WHEN FLAPS ARE ZERO, PODIUMS ARE LARGER THAN 0, SEASON IS 2008, AND POLE SMALLER THAN 1?
SQL: SELECT SUM("races") FROM iannone_stats WHERE "flaps" = 0 AND "podiums" > 0 AND "season" = '2008' AND "pole" < 1

Question: WHAT ARE THE RACES WITH A POLE SMALLER THAN 2 IN 2007?
SQL: SELECT MIN("races") FROM iannone_stats WHERE "pole" < 2 AND "season" = '2007'

Question: WHAT ARE THE RACES FOR 2010 WITH FLAPS LARGER THAN 6?
SQL: SELECT MAX("races") FROM iannone_stats WHERE "season" = '2010' AND "flaps" > 6