How many camera lenses are not used in taking any photos?
create table photos (id varchar, camera_lens_id varchar, PRIMARY KEY (id)); create table camera_lens (id varchar, camera_lens_id varchar, PRIMARY KEY (id))
select count(*) from camera_lens where not id in (select camera_lens_id from photos)