How many camera lenses have a focal length longer than 15 mm?
create table camera_lens (focal_length_mm integer, PRIMARY KEY (focal_length_mm))
select count(*) from camera_lens where focal_length_mm > 15