How many camera lenses are not used in taking any photos?
SELECT count(*) FROM camera_lens WHERE id NOT IN ( SELECT camera_lens_id FROM photos )
camera lenses not used in taking any photos refers to lenses without associated photos in the photos table; count of such lenses = COUNT(*) WHERE lens id NOT IN (photos table camera_lens_id);