What was the start date of the most recent appointment?
select start from appointment order by start asc limit 1
What is the patient associated with the appointment on 2008-04-24 10:00?
select patient from appointment where start = '2008-04-24 10:00'
Can you list the patient IDs associated with appointment IDs 93216548 and 86213939?
select patient from appointment where appointmentid = 93216548 or appointmentid = 86213939
Can you list the names associated with those patient ID 100000004 and 100000002?
select distinct ( t1.name ) from patient as t1 join appointment as t2 on t1.ssn = t2.patient where t2.patient = 100000004 or t2.patient = 100000002