CREATE TABLE mountain (id NUMBER, name CLOB, height NUMBER, prominence NUMBER, range CLOB, country CLOB)
CREATE TABLE camera_lens (id NUMBER, brand CLOB, name CLOB, focal_length_mm NUMBER, max_aperture NUMBER)
CREATE TABLE photos (id NUMBER, camera_lens_id NUMBER, mountain_id NUMBER, color CLOB, name CLOB)

Find the brand and name for each camera lens, and sort in descending order of maximum aperture.
SELECT brand, name FROM camera_lens ORDER BY max_aperture DESC
SELECT "brand", "name" FROM "camera_lens" ORDER BY "max_aperture" DESC