Page Comparison

SELECT
to_date(createdate) AS "Create Date",
type AS "Claim Type",
category AS "Claim Category",
SUM(d.disputeamount) as "Dispute Amount"
FROM
disputes AS d
WHERE
tenant= 'YOURTENANTIDHERE'
AND createdate=:daterange
GROUP BY
"Create Date", type, category
ORDER BY
"Create Date" DESC, type DESC, category DESC