Table: xdcam_details
Columns: format_name
container
video_coding
bit_depth
color_sampling
frame_size
video_bit_rate_mbit_s
audio_coding

Question: What type of video coding has a format name of dvcam?
SQL: SELECT "video_coding" FROM xdcam_details WHERE "format_name" = 'dvcam'

Question: What format name has dv as video coding and 4:1:1 as the color sampling?
SQL: SELECT "format_name" FROM xdcam_details WHERE "video_coding" = 'dv' AND "color_sampling" = '4:1:1'

Question: What bit depth has 4:1:1 as the color sampling?
SQL: SELECT SUM("bit_depth") FROM xdcam_details WHERE "color_sampling" = '4:1:1'

Question: What bit depth average has a video bit rate, Mbit/s of 25 (cbr), and 4:1:1 as color sampling?
SQL: SELECT AVG("bit_depth") FROM xdcam_details WHERE "video_bit_rate_mbit_s" = '25 (cbr)' AND "color_sampling" = '4:1:1'

Question: What frame size has pcm 4 ch/16 bit/48khz as audio coding and dvcam as the format name and 4:1:1 as the color sampling?
SQL: SELECT "frame_size" FROM xdcam_details WHERE "audio_coding" = 'pcm 4 ch/16 bit/48khz' AND "format_name" = 'dvcam' AND "color_sampling" = '4:1:1'