Table: kanaan_stats
Columns: year
team
chassis
engine
rank
points

Question: What is the total number of points for the KV Racing Technology team when they use a chevrolet engine?
SQL: SELECT COUNT("points") FROM kanaan_stats WHERE "engine" = 'chevrolet' AND "team" = 'kv racing technology'

Question: Which engine has a chassis of dallara, is ranked 6th, and has 384 points?
SQL: SELECT "engine" FROM kanaan_stats WHERE "chassis" = 'dallara' AND "rank" = '6th' AND "points" = 384

Question: Which engine is used when there is a 3rd place rank and 513 points?
SQL: SELECT "engine" FROM kanaan_stats WHERE "rank" = '3rd' AND "points" = 513

Question: What is the chassis when the rank is 3rd?
SQL: SELECT "chassis" FROM kanaan_stats WHERE "rank" = '3rd'

Question: What are the years that Andretti Autosport is a team?
SQL: SELECT COUNT("year") FROM kanaan_stats WHERE "team" = 'andretti autosport'

Question: Which team is ranked 3rd in 2008?
SQL: SELECT "team" FROM kanaan_stats WHERE "rank" = '3rd' AND "year" = 2008