Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Summarize and visualize the data from your SQL query for question five above in whatever manner you think does the best job of presenting the

Summarize and visualize the data from your SQL query for question five above in whatever manner you think does the best job of presenting the data.

(See five questions below)

  1. Submit a statement using the ADMISSIONS table that will provide some demographic information on the patient admitted to the hospital. Your statement could include things like their religion, there marital status, the type of admission etc. The choice is up to you, but try to select things that you think could be potentially beneficial to better understanding the hospital population.

SELECT religion, marital_status, admission_type, admission_location, discharge_location FROM ADMISSIONS; This statement will provide demographic information on patients admitted to the hospital, including their religion, marital status, type of admission, admission location, and discharge location.

  1. Submit a statement using the CHARTEVENTS table that will provide the charttime, itemid, values and valueuom for patient ID=10045 for any chartevents involving itemid = 211

SELECT charttime, itemid, value, valueuom FROM CHARTEVENTS WHERE subject_id = 10045 AND itemid = 211

  1. Submit a statement using the D_LABITEMS table that will summarize the fluids and the counts of each type of fluid, grouped by category. Do you notice anything unusual about this output?If so, comment on what you think might be going on. BONUS: If you feel like you know what could be wrong, try to Google for how you might fix it.

SELECT CATEGORY, FLUID, COUNT(*) AS COUNT FROM D_LABITEMS WHERE CATEGORY LIKE '%FLUIDS%' GROUP BY CATEGORY, FLUID; The output of this query may vary depending on the data in the D_LABITEMS table, but if there are any null values in the FLUID column, they may be grouped together as a single category. This could result in an unusually high count for the null category. To fix this, you could add a condition to the WHERE clause to exclude null values, such as "WHERE CATEGORY LIKE '%FLUIDS%' AND FLUID IS NOT NULL".

  1. Submit a 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

SELECT * FROM PRESCRIPTIONS WHERE PATIENT_ID = 10032; This will provide all the prescriptions ever prescribed to the patient with ID =10032. However, if you want a more useful summary, you can modify the SELECT statement to include only the relevant columns such as prescription ID, medication name, dosage, start date, end date, and prescribing doctor. For example: SELECT PRESCRIPTION_ID, MEDICATION_NAME, DOSAGE, START_DATE, END_DATE, PRESCRIBING_DOCTOR FROM PRESCRIPTIONS WHERE PATIENT_ID = 10032; This will provide a summary of all the prescriptions ever prescribed to the patient with ID =10032, including the prescription ID, medication name, dosage, start date, end date, and prescribing doctor.

  1. Submit one select statement of your own and complete steps a,b and c for that statement.

SELECT name, age, city FROM users WHERE age > 25; a) This statement selects the columns "name", "age", and "city" from the table "users". b) It filters the results to only include rows where the "age" column is greater than 25. c) The output will show the names, ages, and cities of all users who are older than 25.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MIS Essentials

Authors: David M Kroenke

1st Edition

0136075606, 9780136075608

More Books

Students also viewed these General Management questions

Question

=+b) Drivers scores on the written part of a driving test.

Answered: 1 week ago