Ask
Questions are answered from the dictionary's own SQL, so a number here is the number the operator acts on. When a term has two meanings, both answers come back with how far they overlap.
How many active listings do we have?late shipments last 7 daysnet sales this weekchargebacks in the windowclean returns last 30 daysstock on hand
28 chargebacks according to the finance lead (payments v1).
28 chargebacks
28 chargebacks according to the finance lead (payments v1)
SQL
SELECT c.id AS chargeback_id, m.name AS marketplace, c.reason, c.amount, c.respond_by,
c.evidence_filed_at <= TIMESTAMP '2026-11-28 00:00:00' AS evidence_filed
FROM chargebacks c JOIN marketplaces m ON m.id = c.marketplace_id
WHERE c.opened_at <= TIMESTAMP '2026-11-28 00:00:00' AND c.respond_by > TIMESTAMP '2026-11-28 00:00:00' AND c.respond_by <= TIMESTAMP '2026-11-28 00:00:00' + INTERVAL (72) HOUR
ORDER BY c.respond_by