Show the id of all the camera lenses used for taking photos.
select camera_lens_id from photos
Which camera lenses were not used for taking any photos?
select * from camera_lens where id not in ( select camera_lens_id from photos )
How many are there?
select count(*) from camera_lens where id not in ( select camera_lens_id from photos )