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
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 as t1 join photos as t2 on t1 . id = t2 . mountain_id group by t1 . id having count ( * ) > = value
What are the id and name of the mountains that have at least 2 photos ?