CREATE TABLE table_name_48 (team VARCHAR, sponsor VARCHAR, tire VARCHAR, chassis VARCHAR)

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