CREATE TABLE table_1947 ("Period" CLOB, "Kit manufacturer" CLOB, "Main sponsor" CLOB, "Secondary sponsor" CLOB, "Minor sponsors" CLOB)

When ale is the main sponsor who is the secondary sponsor?
SELECT "Secondary sponsor" FROM table_1947 WHERE "Main sponsor" = 'Ale'
SELECT "Secondary sponsor" FROM "table_1947" WHERE "Main sponsor" = 'Ale'