Webhook Retries in the Metric

#977

Operations needs to know how many different orders received events in webhook_events. Retries for the same order_id must not inflate the metric. Fix the report so it returns one value, n, for the number of unique orders.

Buggy query

SELECT COUNT(*) AS n FROM webhook_events;

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

n
2

Your query result will appear here