List the doctor ID, first name, last name, and count of appointments for each doctor.Combine the first and last name into one column and use the following column headings:Dr ID, Dr Name, Appt Count. Sort by doctor last name.

List the patient ID, patient first name, patient last name, and total number of appointments for each patient.Sort by appointment count in descending order.Use the following column headings:Patient ID, Patient First Name, Patient Last Name, Appt Count.

For each appointment, list the appt ID, date, patient ID, patient first name, patient last name, doctor ID, doctor last name, and count of reason codes; combine the patient first and last name into one column, and sort by count of reason codes in descending order, then by appt ID in ascending order. Show the date formatted as ‘mm-dd-yyyy.’ Use the following column headings: Appt, Date, Patient ID, Patient Name, Dr ID, Dr Name, Code Count.

List the appt ID, appt date, appt time, and total number of minutes for the appointment(s) with the highest total minutes.Sort by appt ID.Use the following column headings:ApptID, Date, Time, TotalMinutes.

Transcribed Image Text:

Relationship Tools Project1: Database- CAUsersmichalOrieDrive\Documents\Database Class\ProjectiProject1.accdb. Michaei Potterson File Home Create Extemal Data Database Tools Help Design P Tell me what you want to do All.. O E Relationships Search. Tables Insurance Company E V Ins Co ID Is Co Name Appointme. Doctor Info Appointme. Y DrID E Appointme. Dr First Name Dr Last Name E Appointme. Appointment I Billing Status 8 Appt ID Appt Date I Block Code Block Code Appt Time E Doctor Info Patient ID Appointment Block 7 Block Code E Appointment Status Block Code Desc * Appt ID Appt Reason Code Insurance Patient Info Block Time Biing Type E Patient Info Patient ID Appt Reason Desc Patient First Name Patient Last Name Patient Phone Billing Status Appointment Reason Appointment Status V Billing Type Appointment Status Code Appt Status Desc V Appt Reason Code Appt Reason Dese Billing Type Desc Ready 5:33 PM O Type here to search ロ 底 小 10/16/2018 Relationship Tools Project1: Database- CAUsersmichalOrieDrive\Documents\Database Class\ProjectiProject1.accdb. Michaei Potterson File Home Create Extemal Data Database Tools Help Design P Tell me what you want to do All.. O E Relationships Search. Tables Insurance Company E V Ins Co ID Is Co Name Appointme. Doctor Info Appointme. Y DrID E Appointme. Dr First Name Dr Last Name E Appointme. Appointment I Billing Status 8 Appt ID Appt Date I Block Code Block Code Appt Time E Doctor Info Patient ID Appointment Block 7 Block Code E Appointment Status Block Code Desc * Appt ID Appt Reason Code Insurance Patient Info Block Time Biing Type E Patient Info Patient ID Appt Reason Desc Patient First Name Patient Last Name Patient Phone Billing Status Appointment Reason Appointment Status V Billing Type Appointment Status Code Appt Status Desc V Appt Reason Code Appt Reason Dese Billing Type Desc Ready 5:33 PM O Type here to search ロ 底 小 10/16/2018

Answer rating: 100% (QA)

1 select dDoctorID as Dr ID concatdDoctorFName dDoctorLName as Dr Name countdistinct ApptID as Appt ... View the full answer