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

Question:  how many chroma format with name being high profile
SQL: SELECT COUNT("chroma_format") FROM mpeg2_part2_profiles WHERE "name" = 'High profile'

Question: what's the chroma format with scalable modes being snr- or spatial-scalable and intra dc precbeingion being 8, 9, 10
SQL: SELECT "chroma_format" FROM mpeg2_part2_profiles WHERE "scalable_modes" = 'SNR- or spatial-scalable' AND "intra_dc_precision" = '8, 9, 10'

Question: what's the chroma format with name being high profile
SQL: SELECT "chroma_format" FROM mpeg2_part2_profiles WHERE "name" = 'High profile'