CREATE TABLE appointment (appointmentid VARCHAR, START VARCHAR)

Find the id of the appointment with the most recent start date?
SELECT appointmentid FROM appointment ORDER BY START DESC LIMIT 1
SELECT "appointmentid" FROM "appointment" ORDER BY "START" DESC NULLS LAST LIMIT 1