Table: video_resolution
Columns: vertical
horizontal
aspect_ratio
pixel_aspect_ratio
scanning
frame_rate_hz

Question: What was the aspect ratio if the vertical pixel is 480 and pixel aspect ratio is 1:1?
SQL: SELECT "aspect_ratio" FROM video_resolution WHERE "vertical" = 480 AND "pixel_aspect_ratio" = '1:1'

Question: What was the minimum vertical measurement if the aspect ratio is 16:9 and scanning is interlaced?
SQL: SELECT MIN("vertical") FROM video_resolution WHERE "aspect_ratio" = '16:9' AND "scanning" = 'interlaced'

Question: What was the maximum vertical measurement if the horizon measurement is 640?
SQL: SELECT MAX("vertical") FROM video_resolution WHERE "horizontal" = 640