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

What are the id and name of the mountains that have at least 2 photos?
SELECT T1.id, T1.name FROM mountain AS T1 JOIN photos AS T2 ON T1.id = T2.mountain_id GROUP BY T1.id HAVING COUNT(*) >= 2
SELECT "T1"."id", "T1"."name" FROM "mountain" "T1" JOIN "photos" "T2" ON "T1"."id" = "T2"."mountain_id" GROUP BY "T1"."id" HAVING COUNT(*) >= 2