CREATE TABLE table_201_42 (id NUMBER, "year" CLOB, "title" CLOB, "role" CLOB, "notes" CLOB)

list the titles that include host as the role .
SELECT "title" FROM table_201_42 WHERE "role" = 'host'
SELECT "title" FROM "table_201_42" WHERE "role" = 'host'