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 is the name of each camera lens and the number of photos taken by it? Order the result by the count of photos.
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 ( * )
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 is the name of each camera lens and the number of photos taken by it ? Order the result by the count of photos .