Table: mpeg2_part2_profiles_2
Columns: abbr
name
picture_coding_types
chroma_format
aspect_ratios
scalable_modes
intra_dc_precision

Question: What Picture Coding Types have Chroma Format of 4:2:2 or 4:2:0 and the Name of 4:2:2 profile?
SQL: SELECT "picture_coding_types" FROM mpeg2_part2_profiles_2 WHERE "chroma_format" = '4:2:2 or 4:2:0' AND "name" = '4:2:2 profile'

Question: Name the Intra DC Precision that has the Name main profile?
SQL: SELECT "intra_dc_precision" FROM mpeg2_part2_profiles_2 WHERE "name" = 'main profile'

Question: What Chroma Format that has both Picture Coding Types of i, p, b, and the Name of main profile?
SQL: SELECT "chroma_format" FROM mpeg2_part2_profiles_2 WHERE "picture_coding_types" = 'i, p, b' AND "name" = 'main profile'