Who is the producer for the director Richard Clark?
CREATE TABLE "production" (
  "block" real,
  "director" text,
  "writers" text,
  "producer" text,
  "code" text
);
SELECT "producer" FROM "production" WHERE "director"='richard clark';