CREATE TABLE table_name_30 (captain VARCHAR2, kit_manufacturer VARCHAR2)

Who is the captain of the team that has a kit manufacturer of Fox Leisure?
SELECT captain FROM table_name_30 WHERE kit_manufacturer = "fox leisure"
SELECT "captain" FROM "table_name_30" WHERE "fox leisure" = "kit_manufacturer"