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