Who ran unsuccessfully against Bill Hefner?
CREATE TABLE "north_carolina" (
  "district" text,
  "incumbent" text,
  "party" text,
  "first_elected" real,
  "status" text,
  "opponent" text
);
SELECT "opponent" FROM "north_carolina" WHERE "incumbent"='Bill Hefner';