Wednesday, October 19, 2011

Sum of Payment per ZipCode, ordered

SELECT SUM([ Net_Paid ]) Payment,
[ Employee_ZIP_Code ] ZIP,
NTILE(10) OVER (ORDER BY SUM([ Net_Paid ])) AS Decile
  FROM [SiemensHealthPlanData].[dbo].[unitedHealth]
  group by [ Employee_ZIP_Code ]

No comments:

Post a Comment