CREATE TABLE table_name_31 (producer VARCHAR2, director VARCHAR2)

Who is the producer for the director Richard Clark?
SELECT producer FROM table_name_31 WHERE director = "richard clark"
SELECT "producer" FROM "table_name_31" WHERE "director" = "richard clark"