CREATE TABLE table_30430 ("Club name" CLOB, "Name of team song" CLOB, "Basis for team song" CLOB, "First used as team song" CLOB, "Writer/composer" CLOB)

Which team has a song based on 'wee deoch an doris'?
SELECT "Club name" FROM table_30430 WHERE "Basis for team song" = 'Wee Deoch an Doris'
SELECT "Club name" FROM "table_30430" WHERE "Basis for team song" = 'Wee Deoch an Doris'