[Expert Solution]: Database: (Excel) Simple Reports – Database…

Database: (Excel) Simple Reports – Database 2022 N-1.xls Download Simple Reports – Database 2022 N-1.xls Instructions You are to read the following report request. Then using Data Manipulation Language (DML) and ICD 10 CM/PCS codes, you are to retrieve the data from the database (Excel report). List your search process and then provide the patient names you found that met the criteria for your request. First you need to determine the ICD-10-CM or PCS code needed in each scenario. Then using the data tab on excel, use the filter funnel. This will put little down arrows under each column in the excel spreadsheet. Go through each scenario and “filter” your criteria until you have the patients who meet each scenario need. Example: Search for all Female patients Search for all HAP insurance types Search for all disposition of home My search found: Mary Jones , Lisa Smith, and Susan Brown Request 1 Find all patients who left AMA with a diagnosis of atypical chest pain. Request 2 Provide a listing of all patients with a diagnosis of anxiety with depression due to an acute stress reaction and were discharged to a psychiatric hospital. Request 3 Provide a listing of all patients discharged with an insurance type of Allstate, who are age 70 and had a diagnosis of congestive heart failure. Request 4 Search for all male patients who had a radical prostatectomy performed via laparoscopic robotic assistance that went home and had Blue Cross health insurance. Request 5 Search for all Females who were discharged in April of 2020 who had a non-displaced lateral malleolus fracture of the right ankle and an ORIF. Request 6 Search for all patients treated by (attending) Dr. Tom Horton who had a diagnosis of COVID with pneumonia and were on a ventilator for more than 96 hours. Request 7 Search for all patients discharged on May 14, 2020 with a principal diagnosis of prostate cancer and a complication of gross hematuria who had chemotherapy done on this admission and were discharged to Home Hospice. Request 8 Search for all of Dr. Howsner’s patients from 1st Quarter 2020 who had a laparoscopic cholecystectomy for acute cholecystitis. Request 9 Search for all cases on women age 55 or older with a diagnosis of breast cancer that had a lumpectomy performed. Request 10 Find all patients that had an insurance provider of BCBSM and had a carpal tunnel release performed during their stay.