Find the number of appointments each patient has made.
select count(*) from appointment group by patient
Which patients made more than one appointment?
select * from appointment group by patient having count(*) > 1
Tell me the name and phone number of these patients
select name, phone from appointment as t1 join patient as t2 on t1.patient = t2.ssn group by t1.patient having count(*) > 1