SELECT SUM([ Net_Paid ]) Payment,
NTILE(10) OVER (ORDER BY SUM([ Net_Paid ])) AS Decile
FROM [SiemensHealthPlanData].[dbo].[unitedHealth]
group by [ Employee_Sex ]
,[ Employee_ZIP_Code ]
,[ Employee_Status ]
,[ Employee_Date_of_Birth ]
,[ Dependent_Number ]
,[ Member_Relationship_Code ]
,[ Member_Date_of_Birth ]
,[ Member_Sex ]
,[ Member_Market ]
No comments:
Post a Comment