In which category is Frank Scarabino a pilot?
CREATE TABLE "aircraft" (
  "category" text,
  "speed_km_h" real,
  "speed_mph" real,
  "vehicle" text,
  "pilot" text,
  "date" text
);
SELECT "category" FROM "aircraft" WHERE "pilot"='frank scarabino';