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 NUMBER, max_aperture NUMBER)
CREATE TABLE mountain (id NUMBER, name CLOB, height NUMBER, prominence NUMBER, range CLOB, country CLOB)

What are the names of the cameras that have taken picture of the most mountains?
SELECT T2.name FROM photos AS T1 JOIN camera_lens AS T2 ON T1.camera_lens_id = T2.id GROUP BY T2.id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T2"."name" FROM "photos" "T1" JOIN "camera_lens" "T2" ON "T1"."camera_lens_id" = "T2"."id" GROUP BY "T2"."id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY