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)

Group and count the color scheme for all the photos using a pie chart.
SELECT color, COUNT(color) FROM photos GROUP BY color
SELECT "color", COUNT("color") FROM "photos" GROUP BY "color"