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

A bar chart for what are the number of the names of photos taken with the lens brand 'Sigma' or 'Olympus'?, show from high to low by the Y-axis.
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 COUNT(T1.name) DESC
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 COUNT("T1"."name") DESC