a.Calculate the total paid PMPM for SNF claims incurred in 2015.

In addition, calculate total count of SNF admissions, the average length of stay, and the total cost per admission, for SNF claims incurred in 2015.

(Hint: for paid PMPM use one query to sum total paid, another to sum total member months, then calculate total paid PMPM using the results of these queries outside of SQL)

Are SQL files

selectfinal_2015_members

selectfinal_member_months

selectfinal_snf_claims

Here are the rows of the final_snf_claims:

PATIENT_ID

SNF_ADMIT_DATE

SNF_DISCHARGE_DATE

SNF_NAME

SNF_PREFERRED_FLAG

SNF_ADMIT_MONTH

TOTAL_PAID

product_line

Here is the answer of the question to an older version of the question.

SELECT SUM (MEMBER_MONTH)AS sum_member_months_2015

FROM final.dbo.member_months

WHERE ELIGIBILITY_MONTH Between '01jan2015' and '31dec2015';

20979

SELECT SUM (Total_Paid)AS sum_claims_2015

FROM final.dbo.snf_claims

WHERE SNF_ADMIT_MONTH Between '01jan2015' and '31dec2015';

32880611

SELECT COUNT(SNF_ADMIT_DATE)AS total_admissions_2015

FROM final.dbo.snf_claims

WHERE SNF_ADMIT_MONTH Between '01jan2015' and '31dec2015';

2457

SELECTAVG(DATEDIFF(D, SNF_ADMIT_DATE, SNF_DISCHARGE_DATE))AS avg_stay_length_2015

FROM final.dbo.snf_claims

WHERE SNF_ADMIT_MONTH Between '01jan2015' and '31dec2015';

11