CREATE TABLE table_name_80 (director VARCHAR, role VARCHAR)

Which Director has a Role of melissa?
SELECT director FROM table_name_80 WHERE role = "melissa"
SELECT "director" FROM "table_name_80" WHERE "melissa" = "role"