The diagram describes a simple database for a small clinic. It includes tables with information about Physicians, Patients, Consultations, Medicine, Clinical Testing and Follow Up. Every Physician, Patient, Medicine, and Clinical Testing in the system contains a record within their corresponding Table. Every time a patient visits a physician, a unique consultation record is created. After the consultation ends, a set of RequestedClinicalTests may be ordered, Medication for Patients may be filled and FollowUp records may also be created. Assume that the fields named Salary, Dosage, Quantity, and UnitCost are the only numeric fields in the database. All other fields are strings (TEXT). The fields Date and DOB can be transformed to the format MM-DD-YYYY (01-31-1950, for example) by using the function Format(, MM-DD-YYYY). A particular month could also be obtained as a number using the function MONTH(<.date-field>). The design also shows the 1-to-many relationships that govern this application.

Question: List the first and last names of all physicians with specialty of Geriatrics who prescribed the medicine called Aspirine. Avoid physician duplications.

Use WHERE instead of JOIN in the queries

Physician \begin{tabular}{|l|l|l|l|l|l|} \hline FirstName & LastName & ID & Specialty & Phone & Salary \\ \hline \end{tabular} ClinicalTests