Table: leaf_camera_specs
Columns: model
sensor_size
resolution
active_pixels
display

Question: What is the resolution of the camera that has 6726 x 5040 pixels and a model of afi 7?
SQL: SELECT "resolution" FROM leaf_camera_specs WHERE "active_pixels" = '6726 x 5040' AND "model" = 'afi 7'

Question: Which model has a sensor sized 48x36 mm, pixels of 6726 x 5040, and a 33 mp resolution?
SQL: SELECT "model" FROM leaf_camera_specs WHERE "sensor_size" = '48x36 mm' AND "active_pixels" = '6726 x 5040' AND "resolution" = '33 mp'

Question: What are the active pixels of the cantare model?
SQL: SELECT "active_pixels" FROM leaf_camera_specs WHERE "model" = 'cantare'

Question: What are the active pixels of the c-most model camera?
SQL: SELECT "active_pixels" FROM leaf_camera_specs WHERE "model" = 'c-most'