What's the category for the tween academy: class of 2012 nomination?
CREATE TABLE "awards_and_nominations" (
  "year" real,
  "award_giving_body" text,
  "category" text,
  "nominated_for" text,
  "result" text
);
SELECT "category" FROM "awards_and_nominations" WHERE "nominated_for"='tween academy: class of 2012';