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

Bar chart x axis color y axis the number of color, and I want to sort how many color from high to low order.
SELECT color, COUNT(color) FROM photos GROUP BY color ORDER BY COUNT(color) DESC
SELECT "color", COUNT("color") FROM "photos" GROUP BY "color" ORDER BY COUNT("color") DESC NULLS LAST