Question 1: Using the attached data previously provided to you, do the following tasks as separate SQLs.
1. Remove visits from dead patients and count distinct number of remaining patients
2. Remove diagnoses before birth, i.e. negative age of diagnosis and count number of distinct diagnoses remaining
3. Remove patients with more than 365 diagnosis per year of age and count number of patients remaining
4. Remove diagnoses after age of 110
5. Remove diagnoses with no age of diagnosis
6. Find the oldest person in the data
7. Remove patients with less than 365 days between their first and last diagnosis.
8. Report the number of distinct patients who have only 1 diagnosis
9. For patients who have diabetes, identify the average age of diabetes and standard deviation of the age of diabetes. Define as diabetic any patient who meets the AHRQ requirement for diabetes
Provide your SQL code as well as answers but no data.
Question 2: Assess the average impact of CHF on length of stay while controlling for all other comorbidities. To do this, compare all cases with CHF to all controls without the disease. Make sure that in each comparison, patients with and without disease have the same set of comorbidities. Produce a table with the 10 estimates n1 through n10 provided below.
|
Strata
|
Cases of CHF
|
Controls with No CHF
|
Difference
|
|
AA
|
n1
|
n6
|
n1-n6
|
|
AA, MI
|
n2
|
n7
|
n2-n7
|
|
AA,DM
|
n3
|
n8
|
n3-n8
|
|
DM, MI
|
n4
|
n9
|
n4-n9
|
|
AA,DM,MI
|
n5
|
n10
|
n5-n10
|
|
Case
|
1st Diagnosis
|
2nd Diagnosis
|
3rd Diagnosis
|
4th Diagnosis
|
Length of stay
|
Number of Patients
|
|
Type
|
|
1
|
MI
|
CHF
|
DM
|
|
5.56
|
10
|
|
2
|
MI
|
|
|
AA
|
4.1
|
10
|
|
3
|
|
CHF
|
DM
|
AA
|
5.54
|
10
|
|
4
|
|
CHF
|
DM
|
|
3.56
|
20
|
|
5
|
MI
|
CHF
|
|
AA
|
7.03
|
30
|
|
6
|
MI
|
CHF
|
|
|
5.02
|
30
|
|
7
|
|
CHF
|
|
AA
|
5.04
|
30
|
|
8
|
MI
|
CHF
|
DM
|
AA
|
7.62
|
40
|
|
9
|
MI
|
|
|
|
2.03
|
40
|
|
10
|
|
CHF
|
|
|
3.03
|
40
|
|
11
|
MI
|
|
DM
|
|
2.6
|
50
|
|
12
|
|
|
DM
|
AA
|
2.57
|
50
|
|
13
|
|
|
DM
|
|
0.61
|
60
|
|
14
|
|
|
|
AA
|
2.12
|
70
|
|
15
|
|
|
|
|
0.01
|
80
|
|
16
|
MI
|
|
DM
|
AA
|
4.57
|
120
|
|
MI = Myocardial Infarction; CHF = Congestive Heart Failure; DM=Diabetes Mellitus; AA=Alcohol abuse
|
Attachment:- Assignment File.rar