Charges by Place of Service and Year

SELECT 
   sum(chgsplamt) as "totalcharge",
   defcode as "POS",
   year(trandate) as "year"
FROM 
   sos.rv_charges a join sos.poscodes b on a.poscodenum=b.poscodenum
GROUP BY POS,year