What Category has a Result of Nominated, Year of 2006, and the Title of Pierrepoint?
CREATE TABLE "awards_and_nominations" (
  "year" real,
  "award" text,
  "category" text,
  "title" text,
  "result" text
);
SELECT "category" FROM "awards_and_nominations" WHERE "result"='nominated' AND "year"=2006 AND "title"='pierrepoint';