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

What are the number of the names of photos taken with the lens brand 'Sigma' or 'Olympus'?, could you list by the name in ascending?
SELECT T1.name, COUNT(T1.name) FROM camera_lens AS T1 JOIN photos AS T2 ON T2.camera_lens_id = T1.id WHERE T1.brand = 'Sigma' OR T1.brand = 'Olympus' GROUP BY T1.name ORDER BY T1.name
SELECT "T1"."name", COUNT("T1"."name") FROM "camera_lens" "T1" JOIN "photos" "T2" ON "T1"."id" = "T2"."camera_lens_id" WHERE "T1"."brand" = 'Olympus' OR "T1"."brand" = 'Sigma' GROUP BY "T1"."name" ORDER BY "T1"."name"