what are name and phone number of patients who had more than one appointment?
SELECT name ,  phone FROM appointment AS T1 JOIN patient AS T2 ON T1.patient  =  T2.ssn GROUP BY T1.patient HAVING count(*)  >  1
patients who had more than one appointment refers to HAVING COUNT(*) > 1; name and phone number of patients refers to SELECT name, phone;