How would the following query be adjusted to show the NurseName instead of NurseID next to their totals?

SELECT b.NurseID, SUM(Cost) AS 'Total Cost'
FROM Appointment AS b
JOIN Nurse
ON b.NurseID = Nurse.NurseID
GROUP BY NurseID

Transcribed Image Text:

Nurse PK NurselD NurseName Hospital PK HospitalID HospitalName Hospital City Appointment PK AppointmentID FK PatientID FK FK FK Doctor PK DocID DocName Specialty Cost NurselD DocID RoomNumber Date Start Time DateEnd Time Room PK RoomNumber RoomDesc Patient PK PatientID PatientName Address Nurse PK NurselD NurseName Hospital PK HospitalID HospitalName Hospital City Appointment PK AppointmentID FK PatientID FK FK FK Doctor PK DocID DocName Specialty Cost NurselD DocID RoomNumber Date Start Time DateEnd Time Room PK RoomNumber RoomDesc Patient PK PatientID PatientName Address