Reference no: EM131415474

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