Find the id of the appointment with the most recent start date?
SELECT appointmentid FROM appointment ORDER BY START DESC LIMIT 1
most recent start date refers to MAX(START); id of the appointment refers to appointmentid;