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

How many camera lenses have a focal length longer than 15 mm?
SELECT COUNT(*) FROM camera_lens WHERE focal_length_mm > 15
SELECT COUNT(*) FROM "camera_lens" WHERE "focal_length_mm" > 15