Table: red_cam_specs
Columns: frame_size
width
height
mpix
aspect_ratio
max_fps
lowest_possible_redcode_at_24_fps

Question: What camera has the highest Mpix with an aspect ratio of 2:1, a height less than 1536, and a width smaller than 2048?
SQL: SELECT MAX("mpix") FROM red_cam_specs WHERE "aspect_ratio" = '2:1' AND "height" < 1536 AND "width" < 2048

Question: What is the max fps of a camera with mpix larger than 8.4 and frame size of 4k 16:9?
SQL: SELECT COUNT("max_fps") FROM red_cam_specs WHERE "mpix" > 8.4 AND "frame_size" = '4k 16:9'

Question: What frame size corresponds the selection with a max fps of 120, a width of 2048, and height of 1024?
SQL: SELECT "frame_size" FROM red_cam_specs WHERE "max_fps" = 120 AND "width" = 2048 AND "height" = 1024