CREATE TABLE mountain (id INT, name TEXT, Height FLOAT, Prominence FLOAT, Range TEXT, Country TEXT)
CREATE TABLE camera_lens (id INT, brand TEXT, name TEXT, focal_length_mm FLOAT, max_aperture FLOAT)
CREATE TABLE photos (id INT, camera_lens_id INT, mountain_id INT, color TEXT, name TEXT)

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