What is the name of the nurse who 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
What is her employee ID?
select employeeid from nurse as t1 join appointment as t2 on t1.employeeid = t2.prepnurse group by t1.employeeid order by count ( * ) desc limit 1
List all nurses names in alphabetical order
select name from nurse order by name