Wednesday, October 19, 2011

Patient percentile vs Net paid

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