1. The treatment table stores data about the treatment services that patients have received. The chief of physicians needs a listing of patients (last and first name) who have received either a blood glucose or an antibiotic injection (service_id = 82947 or 90788). Use a subquery approach. 2. Modify your query for Question 1 to sort the output by patient last name, and then by patient first name. 3. Modify the query for Question 1 to produce a listing of patients who have not received either a blood glucose or an antibiotic injection (service_id = 82947 or 90788). Use a subquery approach. Use the NOT IN operator. Sort the output by patient last name, and then by patient first name. 4. The prescription table stores data about the medicines that have been prescribed for patients. The chief of pharmacology needs a listing of patients (last and first name) who have received either Valium or Demerol (medicine_code= 9999003 or 9999002). Use a subquery approach.