What is the name of each camera lens and the number of photos taken by it? Order the result by the count of photos.
CREATE TABLE photos (
    camera_lens_id VARCHAR
)

CREATE TABLE camera_lens (
    name VARCHAR,
    id VARCHAR
)
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. ### Input: CREATE TABLE photos (
    camera_lens_id VARCHAR
)

CREATE TABLE camera_lens (
    name VARCHAR,
    id VARCHAR
) ### 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(*)