CREATE TABLE appointment (patient VARCHAR); CREATE TABLE patient (ssn VARCHAR)
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