SELECT count(*) FROM camera_lens WHERE id NOT IN ( SELECT camera_lens_id FROM photos )
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 )
select count ( * ) from camera_lens where id not in ( select camera_lens_id from photos )
How many camera lenses are not used in taking any photos ?