Create a query for the ff: MySQL workbench For each practitioner, list their ID, first name, last
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a query for the ff: MySQL workbench
- For each practitioner, list their ID, first name, last name, the total number of days and the total number of hours they are scheduled to work in a standard week at the Medical Practice. Assume a workday is nine hours long.
- List the Patient's first name, last name and the appointment date and time, for all appointments held on 18/09/2019 by Dr Anne Funsworth.
- List the ID and date of birth of any patient who has not had an appointment and was born before 1950.
- List the patient ID, first name, last name and the number of appointments for patients who have had at least three appointments. List the patients in 'number of appointments' order from most to least.
- List the first name, last name, gender, and the number of days since the last appointment of each patient and 23/09/2019.
- List the full name and full address of each practitioner in the following format exactly.
Dr Mark P. Huston. 21 Fuller Street SUNSHINE, NSW 2343
Make sure you include the punctuation and the suburb in upper case. - Sort the list by last name, then first name, then middle initial.
- List the patient id, first name, last name and date of birth of the fifth oldest patient(s).
- List the patient ID, first name, last name, appointment date (in the format 'Tuesday 17 September, 2019') and appointment time (in the format '14:15 PM') for all patients who have had appointments on any Tuesday after 10:00 AM.
- Create an address list for a special newsletter to all patients and practitioners. The mailing list should contain all relevant address fields for each household. Note that each household should only receive one newsletter.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: