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)

Show the number of brand from each brand, show brand in ascending order.
SELECT brand, COUNT(brand) FROM camera_lens GROUP BY brand ORDER BY brand
SELECT "brand", COUNT("brand") FROM "camera_lens" GROUP BY "brand" ORDER BY "brand" NULLS FIRST