Table: indycar_1995
Columns: team
chassis
engine
tire
sponsor

Question: What is the Chassis of the Honda Engine with a Motorola sponsor?
SQL: SELECT "chassis" FROM indycar_1995 WHERE "engine" = 'honda' AND "sponsor" = 'motorola'

Question: What is the engine of the goodyear tire and Herdez as a sponsor?
SQL: SELECT "engine" FROM indycar_1995 WHERE "tire" = 'goodyear' AND "sponsor" = 'herdez'

Question: What engine does the Tasman Motorsports team have?
SQL: SELECT "engine" FROM indycar_1995 WHERE "team" = 'tasman motorsports'

Question: Which Tire has a Sponsor of Duracell?
SQL: SELECT "tire" FROM indycar_1995 WHERE "sponsor" = 'duracell'

Question: Which team has Firestone Tires a Reynard 95i Chassis and is sponsored by Motorola?
SQL: SELECT "team" FROM indycar_1995 WHERE "tire" = 'firestone' AND "chassis" = 'reynard 95i' AND "sponsor" = 'motorola'