HIM 650 Week 4 Assignment Help | Grand Canyon University
- Grand Canyon University / HIM 650
- 09 Oct 2019
- Price: $10
- Other / Other
HIM 650 Week 4 Assignment Help | Grand Canyon University
SQL Queries |
For this assignment you
will create SQL queries use the following database schema:
1. Patient—PatientID,
Name, DOB
2. Doctor—DoctorID,
Name, MedLicenseNumber, Phone
3. Medication—MedicationID,
BrandName, GenericName
4. Prescription—PrescriptionID,
Date, PatientID, PrescriberID, MedicationID
Specify the SQL queries
to retrieve:
1. A
list of all doctors.
2. The
number of patients who were born before 01/01/1994.
3. The
patient information along with the ID of any prescribing doctor for each
patient.
4. The
prescription information along with patient name, DOB, medication brand name,
and prescribing doctor name sorted by most recent date.
5. The
most prescribed generic medication name.
APA style is not
required, but solid academic writing is expected.