What are the names of photos taken with the lens brand 'Sigma' or 'Olympus'?
create table photos (camera_lens_id varchar, PRIMARY KEY (camera_lens_id)); create table camera_lens (name varchar, id varchar, brand varchar, PRIMARY KEY (name))
select t1.name from camera_lens as t1 join photos as t2 on t2.camera_lens_id = t1.id where t1.brand = 'sigma' or t1.brand = 'olympus'