4. submit a select statement using the PRESCRIPTIONS table that will provide what you believe is a useful summary of all the prescriptions ever prescribed to the patient with ID =10032

I_MBA673 (2).db W AutoSave on Fe - - HW2 MBA 673 . Saved 9 Search Ashley File Edit View Tools Help New Database Open Database Write Changes Revert Changes open Project Save Project Attach Database * Close Database File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share Database Structure Browse Data Edit Pragmes Execute SQL Edit Database Cell Times New Roman ~ 11 ~ A" A Aa Ap O able: PRESCRIPTIONS 8 5 5 4 1 % Fiter in any column Mode: Text Paste Normal No Spacing Heading 1 Editing Dictate Editor Print to a row_id subject_id hadm_id icustay_id startdate enddate drug_type drug drug_name_poe drug_name_generic for BIUab X X A LA DYMO Label Filter Filter Filter Filter Filter Filter Filter Filter Filter Pneumococcal Vac Polyvalent PNEUMOcoccal Vac Polyvalent PNEU Clipboard 32600 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN umococcal Vac Polyvalent Styles Voice Editor Add-in 32601 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Bisacodyl Bisacodyl BISA value. Option two, use the GROUP BY clause to group the rows by the fluid and category 32602 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Bisacody Bisacod Bisacodyl (Rectal) BISA] columns, and then use the HAVING clause to filter out any rows that have a count of 1. 32603 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Senna Senna Senna SENN 32604 42458 159647 2146-07-21 00: 00:00:00 MAIN (pinbi) wnipos agesnoog Docusate Sodium (Liquid) Docusate Sodium (Liquid) DOCL 32605 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Heparin Heparin Heparin Sodium HEPA Type of data currently in cell: Text / Numeric 4. Create a select statement using the PRESCRIPTIONS table that will provide what you believe is 32606 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Simvastatin Simvastatin Simvastatin SIMV 1 character (s) a useful summary of all the prescriptions ever prescribed to the patient with ID =10032 32607 42458 159647 10:00:00 MAIN Aspirin Aspirin ASA8 Remote SELECT * FROM PRESCRIPTIONS WHERE PATIENT_ID = 10032; 32608 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Donepezil onepezil onepezil DONE 10 32609 42458 159647 This will provide all the prescriptions ever prescribed to the patient with ID =10032. However, if you 2146-07-21 00:00:00 214 22 00:00:00 MAIN Gabapentin abapentin Gabapentin GABA Identity Select an identity to connect want a more useful summary, you can modify the SELECT statement to include only the relevant 11 32610 42458 159647 O MAIN Namenda "NF* Memantine MEME DBHub. 10 columns such as prescription ID, medication name, dosage, start date, end date, and prescribing doctor. 12 32611 42458 159647 Local Current Database 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Tolterodine Tolterodine Colterodine TOLT For example: SELECT PRESCRIPTION_ID, MEDICATION_NAME, DOSAGE, START_DATE, 13 159647 END_DATE, PRESCRIBING_DOCTOR FROM PRESCRIPTIONS WHERE PATIENT_ID = 10032; 32612 42458 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Metoprolol Succinate XL Metoprolol Succinate XL Metoprolol Succinate XL TOPR This will provide a summary of all the prescriptions ever prescribed to the patient with ID =10032, 14 32613 42458 159647 2146-07-21 00:00:00 2146-0 10:00:00 MAIN Tamsulosin Tamsulosin Tamsulosin TAMS including the prescription ID, medication name, dosage, start date, end date, and prescribing doctor 15 32614 42458 159647 2146-07-21 00:00:00 2146-07-22 00:00:00 MAIN Docusate Sodium Docusate Sodium Docusate Sodium DOCL 16 59637 42275 128293 290478 2135-10-25 00:00:00 2135-10-27 00:00:00 MAIN Sodium Chloride 0.9% Flush Sodium Chloride 0.9% Flush Sodium Chloride 0.9% Flush NACL Create one select statement of your own and complete steps ab and c for that statement. 17 59638 42275 128293 290478 2135-10-25 00:00:00 2135-10-27 00:00:00 MAIN Heparin Heparin Heparin Sodium HEPA 18 59639 42275 128293 290478 2135-10-25 00:00:00 2135-10-27 00:00:00 MAIN Guaifenesin Guaifenesin Guaifenesin GUAL 19 59640 42275 128293 290478 0-25 00:00:00 2135-10-27 00:00:00 MAIN Albuterol Inhaler Albuterol Inhaler Albuterol Inhaler ALBU 20 59641 42275 128293 2135-10 30:00:00 MAIN Amlodipine Amlodipine Amlodipine AMIC 59642 42275 128293 290478 10:00:00 MAIN Finasteride Finasterid FINAL 59643 42275 128293 290478 2135-10-25 00:00:00 2135-10-27 00:00:00 MAIN Gabapentin abapentin Gabapentin GABA 59644 42275 128293 290478 2135-10-25 00:00:00 2135-10-27 00:00:00 MAIN Levothyroxine Sodium Levothyroxine Sodium Levothyroxine Sodium LEVO 59645 42275 128293 290478 2135-10-25 00:00:00 2135-10-27 00:00:00 MAIN Tamsulosin Tamsulosin Tamsulosin TAMS 75 59646 42275 128293 290478 2135-10-25 00:00:00 2135-10-27 00:00:00 MAIN Tiotropium Bromide Tiotropium Bromide Tiotropium Bromide TIOT 1 - 26 of 10398 | Go to : Page 4 of 5 31 of 2166 words X English (United States) Text Predictions: On Accessibility: Good to go Display Settings [ Focus 9 0 87% SQL Log Plot DB Schema Remote Mostly cloudy Q Search 3:01 AM 6/20/2023 Mostly Q Search