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.
CREATE TABLE mountain (
    id int,
    name text,
    Height real,
    Prominence real,
    Range text,
    Country text
)

CREATE TABLE camera_lens (
    id int,
    brand text,
    name text,
    focal_length_mm real,
    max_aperture real
)

CREATE TABLE photos (
    id int,
    camera_lens_id int,
    mountain_id int,
    color text,
    name text
)
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(*)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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. ### Input: CREATE TABLE mountain (
    id int,
    name text,
    Height real,
    Prominence real,
    Range text,
    Country text
)

CREATE TABLE camera_lens (
    id int,
    brand text,
    name text,
    focal_length_mm real,
    max_aperture real
)

CREATE TABLE photos (
    id int,
    camera_lens_id int,
    mountain_id int,
    color text,
    name text
) ### Response: 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(*)