CREATE TABLE appointment (prepnurse VARCHAR2)
CREATE TABLE nurse (name VARCHAR2, employeeid VARCHAR2)

What is the name of the nurse has the most appointments?
SELECT T1.name FROM nurse AS T1 JOIN appointment AS T2 ON T1.employeeid = T2.prepnurse GROUP BY T1.employeeid ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."name" FROM "nurse" "T1" JOIN "appointment" "T2" ON "T1"."employeeid" = "T2"."prepnurse" GROUP BY "T1"."employeeid" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY