Page Comparison

SELECT
    d.merchant AS "Merchant",
    count(*) AS "Disputes",
    SUM(d.disputeamount) AS "Dispute Amount"
FROM
    disputes AS d
WHERE
    tenanttenantid='YOURTENANTIDHERE'
    AND createdate=:daterange
GROUP BY
    "Merchant"
ORDER BY
    "Merchant" ASC