UNITED Payment vs ZipCode

Employee_ZIP_Code 

--UNITED SUM CHARGE vs ZIP
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 ]
  order by Payment DESC

--UNITED AVG CHARGE (per claim) vs ZIP
SELECT AVG([ Net_Paid ]) Payment, [ Employee_ZIP_Code ] ZIP,
NTILE(10) OVER (ORDER BY AVG([ Net_Paid ])) AS Decile
  FROM [SiemensHealthPlanData].[dbo].[unitedHealth]
  group by [ Employee_ZIP_Code ]
  order by Payment DESC

 

--UNITED AVG CHARGE (per subscriber) vs ZIP
SELECT
AVG(Q1.Payment) AvgPayment, Q1.ZIP
FROM (
    SELECT  SUM([ Net_Paid ]) Payment, [ Employee_ZIP_Code ] ZIP
    FROM    [SiemensHealthPlanData].[dbo].[unitedHealth]
    GROUP BY [Policy_Number ],
      [ Medco_SSN ]
      ,[ Employee_ID ]
      ,[ Member_Last_Name ]
      ,[ Employee_Sex ]
      ,[ Employee_Date_of_Birth ]
      ,[ Employee_ZIP_Code ]
      ,[ Dependent_Number ]
      ,[ Member_Relationship_Code ]
      ,[ Member_First_Name ]
      ,[ Member_Date_of_Birth ]
      ,[ Member_Sex ]
) AS Q1
GROUP BY Q1.ZIP
order by Q1.ZIP

Provider_ZIP_Code 

--UNITED SUM CHARGE vs ZIP
SELECT SUM([ Net_Paid ]) Payment, [ Provider_ZIP_Code ] ZIP,
NTILE(10) OVER (ORDER BY SUM([ Net_Paid ])) AS Decile
  FROM [SiemensHealthPlanData].[dbo].[unitedHealth]
  group by [ Provider_ZIP_Code ]
  order by Payment DESC
 

--UNITED AVG CHARGE (per claim) vs ZIP
SELECT AVG([ Net_Paid ]) Payment, [ Provider_ZIP_Code ] ZIP,
NTILE(10) OVER (ORDER BY AVG([ Net_Paid ])) AS Decile
  FROM [SiemensHealthPlanData].[dbo].[unitedHealth]
  group by [ Provider_ZIP_Code ]
  order by Payment DESC
 
 
--UNITED AVG CHARGE (per patient) vs ZIP
SELECT
AVG(Q1.Payment) AvgPayment, Q1.ZIP
FROM (
    SELECT  SUM([ Net_Paid ]) Payment, [ Provider_ZIP_Code ] ZIP
    FROM    [SiemensHealthPlanData].[dbo].[unitedHealth]
    GROUP BY [Policy_Number ],
      [ Medco_SSN ]
      ,[ Employee_ID ]
      ,[ Member_Last_Name ]
      ,[ Employee_Sex ]
      ,[ Employee_Date_of_Birth ]
      ,[ Employee_ZIP_Code ]
      ,[ Dependent_Number ]
      ,[ Member_Relationship_Code ]
      ,[ Member_First_Name ]
      ,[ Member_Date_of_Birth ]
      ,[ Member_Sex ],
      [ Provider_ZIP_Code ]
) AS Q1
GROUP BY Q1.ZIP
order by Q1.ZIP