Can you list the name of each camera lens and the number of photos taken by it?
select t1.name, count ( * ) from camera_lens as t1 join photos as t2 on t1.id = t2.camera_lens_id group by t1.id
Can you order the table by the count of photos in ascending order?
select t1.name, count ( * ) from camera_lens as t1 join photos as t2 on t1.id = t2.camera_lens_id group by t1.id order by count ( * )
What are the names of all photos taken by Olympus brand cameras?
select t2.name from camera_lens as t1 join photos as t2 on t1.id = t2.camera_lens_id where t1.brand = "Olympus"