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)
CREATE TABLE photos (id NUMBER, camera_lens_id NUMBER, mountain_id NUMBER, color CLOB, name CLOB)

Compare the number of items in each color scheme using a bar chart, rank by the color from high to low.
SELECT color, COUNT(color) FROM photos GROUP BY color ORDER BY color DESC
SELECT "color", COUNT("color") FROM "photos" GROUP BY "color" ORDER BY "color" DESC