Show the number of brand from each brand, and list x-axis in desc order.
CREATE TABLE photos (
    id int,
    camera_lens_id int,
    mountain_id int,
    color text,
    name text
)

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
)
SELECT brand, COUNT(brand) FROM camera_lens GROUP BY brand ORDER BY brand DESC
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: Show the number of brand from each brand, and list x-axis in desc order. ### Input: CREATE TABLE photos (
    id int,
    camera_lens_id int,
    mountain_id int,
    color text,
    name text
)

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
) ### Response: SELECT brand, COUNT(brand) FROM camera_lens GROUP BY brand ORDER BY brand DESC