Table: pvr_formats
Columns: mpeg_1
mpeg_2
mpeg_4_asp_mpeg_4_part_2_i_e_divx_xvid
h_264_mpeg_4_avc_mpeg_4_part_10
quicktime
realvideo

Question: Tell me the MPEG-2 of yes and MPEG-1 of yes
SQL: SELECT "realvideo" FROM pvr_formats WHERE "mpeg_2" = 'yes' AND "mpeg_1" = 'yes'

Question: Tell me the MPEG-1 for real video of no
SQL: SELECT "mpeg_1" FROM pvr_formats WHERE "realvideo" = 'no'