Page Comparison

SELECT
    to_date(createdate) AS "Create Date",
    type AS "Claim Type",
    category AS "Claim Category",
    count(*) as "Disputes"
FROM
    disputes AS d
WHERE
    tenanttenantid='YOURTENANTIDHERE'
    AND createdate=:daterange
GROUP BY
    "Create Date", type, category
ORDER BY
    "Create Date" DESC, type DESC, category DESC