Who was the champion earlier than 1978 when the runner-up was Jimmy Connors?
CREATE TABLE "singles_champions" (
  "location" text,
  "year" real,
  "champion" text,
  "runner_up" text,
  "score" text
);
SELECT "champion" FROM "singles_champions" WHERE "runner_up"='jimmy connors' AND "year"<1978;