arm5077

SELECT medicare.*, 
       peerAverage.average       AS charge_average, 
       ( medicare.average_submitted_chrg_amt - peerAverage.average ) / 
       peerAverage.average * 100 AS difference_from_average, 
       totalAverage.total_difference_average 
FROM   medicare 
       JOIN (SELECT Avg(average_submitted_chrg_amt) AS average, 
                    hcpcs_code, 
                    place_of_service 
             FROM   medicare