Table: indycar_results
Columns: season
race_name
winning_driver
chassis
engine
tires
team

Question: In what year did Tom Sneva win a race?
SQL: SELECT "season" FROM indycar_results WHERE "winning_driver" = 'Tom Sneva'

Question: What kind of chassis did a winning car with a Foyt engine have in 1979?
SQL: SELECT "chassis" FROM indycar_results WHERE "season" = 1979 AND "engine" = 'Foyt'

Question: What team does Al Unser drive for?
SQL: SELECT "team" FROM indycar_results WHERE "winning_driver" = 'Al Unser'

Question: What team has a vehicle with an Offenhauser engine and a McLaren chassis?
SQL: SELECT "team" FROM indycar_results WHERE "chassis" = 'McLaren' AND "engine" = 'Offenhauser'

Question: What team raced with a Foyt engine in the Texas Grand Prix?
SQL: SELECT "team" FROM indycar_results WHERE "race_name" = 'Texas Grand Prix' AND "engine" = 'Foyt'