Query #1 Generate a list of doctors and their specialties in alphabetical order by doctor last name. Your results should look like the following screenshot (but with your own data):
Query #2 Generate a list of all appointments in alphabetical order by patient name and by latest date and time for each patient. The list should also include the doctor scheduled and the receptionist who made the appointment. Your results should look like the following screenshot (but with your own data):
Query #3 Generate a list of all Treatments in alphabetical order by patient name and by latest date for each patient. The list should also include the doctor who performed the treatment and the nurse who assisted. Your results should look like the following screenshot (but with your own data):
