 how many chroma format with name being high profile
CREATE TABLE "mpeg_2_profiles" (
  "abbr" text,
  "name" text,
  "picture_coding_types" text,
  "chroma_format" text,
  "aspect_ratios" text,
  "scalable_modes" text,
  "intra_dc_precision" text
);
SELECT COUNT("chroma_format") FROM "mpeg_2_profiles" WHERE "name"='High profile';