Table: nikon_coolpix_specs
Columns: model
sensor_resolution_size_type
lens_35mm_equiv_zoom_aperture
digital_zoom
lcd_screen_size_pixels

Question: What would the LCD screen size and pixels be for the coolpix 5700?
SQL: SELECT "lcd_screen_size_pixels" FROM nikon_coolpix_specs WHERE "model" = 'coolpix 5700'

Question: What is the lens zoom and aperture for the coolpix 5400?
SQL: SELECT "lens_35mm_equiv_zoom_aperture" FROM nikon_coolpix_specs WHERE "model" = 'coolpix 5400'