Payments by Place of Service and Year

SELECT
  year(c.trandate) AS YEAR,
  defcode AS POS,
  sum(crsplamt) AS "TOTAL PAID"
FROM
  jcrsplits a
  JOIN jcredits b
  JOIN journal c
  JOIN rv_charges d ON a.chgsplnum=d.chgsplnum
  JOIN poscodes e ON d.poscodenum=e.poscodenum
WHERE
  b.credtype <> 'Adjustment'
GROUP BY
  year,pos
ORDER BY
  year,pos