CREATE TABLE table_name_54 (shirt_sponsor VARCHAR, kit_manufacturer VARCHAR)

Who is the shirt sponsor for the manufacturer Nike?
SELECT shirt_sponsor FROM table_name_54 WHERE kit_manufacturer = "nike"
SELECT "shirt_sponsor" FROM "table_name_54" WHERE "kit_manufacturer" = "nike"