Calculate the average cost of each diagnosis sorted from most expensive to least expensive. Exclude all bills with negative or 0 values.

SQL programming helping

Using your final table calculate:

1. Total number of unique patients

2. Total number of unique diagnosis

3. Calculate average and standard deviation of Age.

4. Calculate frequencies of the diagnosis and find the most frequent diagnosis.

5. Total number of alive and total number of dead patients.

6. Total number of alive and total number of dead per ICD9 code (DX)

7. Calculate total number of diabetic patients.

8. Calculate the average, median and standard deviation of age and the frequencies of the diagnosis.

9. Find the most frequent diagnosis.

10. List the top 20 most frequent diagnoses that co-occur.

11. Calculate number of patients who DON’T have Diabetes Mellitus (DM).

12. Provide the number of patients who have Diabetes Mellitus (DM)

Submit your code and screen shot of results in a word file.

1. Import data from the following files into four tables. ptid.xls► claims.xls► icd.xls► cpt.xls►

2. Identify patients that have diabetes in the above database.

3. Calculate the average cost of each diagnosis sorted from most expensive to least expensive. Exclude all bills with negative or 0 values.

4. Show if men are more likely to have diabetes than women.

5. Calculate which month is most likely to have a diagnosis reported.

6. Download the attached file of ICD9 codes and descriptions and find the seven errors in the data, where the same ICD9 code has been assigned different descriptions.