Table: nikon_coolpix_specs
Columns: model
release_date
sensor_res_size
lens_35mmequiv_zoom_aperture
screen_size_pixels
dimensions_w_h_d_mm
weight

Question: What is the screen size and pixel value when the lens aperture is 26–678mm (26×) f /2.8–5?
SQL: SELECT "screen_size_pixels" FROM nikon_coolpix_specs WHERE "lens_35mmequiv_zoom_aperture" = '26–678mm (26×) f /2.8–5'

Question: What is the screen size and pixel value when the dimensions are 115.5×83.7×102.5?
SQL: SELECT "screen_size_pixels" FROM nikon_coolpix_specs WHERE "dimensions_w_h_d_mm" = '115.5×83.7×102.5'

Question: What is the screen size and pixel amount of model p5000 when the dimensions are 98×64.5×41?
SQL: SELECT "screen_size_pixels" FROM nikon_coolpix_specs WHERE "dimensions_w_h_d_mm" = '98×64.5×41' AND "model" = 'p5000'