CREATE TABLE mountain (id VARCHAR2, name VARCHAR2)
CREATE TABLE photos (mountain_id VARCHAR2)

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