Charges By Sort Code

SELECT
  b.lucode AS Code,
  b.remark AS Description,
  SUM(a.chgsplamt) AS Charges  
FROM
  sos.rv_charges a JOIN sos.lookups b ON a.sortcode=b.lunum
WHERE
  trandate BETWEEN '1999-01-01' AND TODAY()
GROUP BY
  b.lucode,b.remark