Table: camera_specs
Columns: frame_size
width
height
mpix
aspect_ratio
maximum_fps
maximum_fps_hdrx
least_compression_at_24_fps
least_compression_at_maximum_fps

Question: What is the sum of Mpix with a maximum fps HDRX of less than 12 with a width larger than 5120?
SQL: SELECT SUM("mpix") FROM camera_specs WHERE "maximum_fps_hdrx" < 12 AND "width" > 5120

Question: What is the lowest maximum of fps with a width of 3072 and a height less than 1620?
SQL: SELECT MIN("maximum_fps") FROM camera_specs WHERE "width" = 3072 AND "height" < 1620

Question: What is the maximum fps HDRx with a height larger than 1080 with a compression at 24 fps of 6:1 with a compression at maximum fps of at least 7:1?
SQL: SELECT "maximum_fps_hdrx" FROM camera_specs WHERE "height" > 1080 AND "least_compression_at_24_fps" = '6:1' AND "least_compression_at_maximum_fps" = '7:1'