CREATE TABLE table_name_8 (film VARCHAR2, writer_s_ VARCHAR2)

Which film did Al Mackay write?
SELECT film FROM table_name_8 WHERE writer_s_ = "al mackay"
SELECT "film" FROM "table_name_8" WHERE "al mackay" = "writer_s_"