CREATE TABLE table_80120 ("Team" CLOB, "Manager" CLOB, "Captain" CLOB, "Kit manufacturer" CLOB, "Shirt sponsor" CLOB)

Which team does David O'leary manage?
SELECT "Team" FROM table_80120 WHERE "Manager" = 'david o''leary'
SELECT "Team" FROM "table_80120" WHERE "Manager" = 'david o''leary'