How to email last week’s numbers so your manager can use them

The query can be right and the email still useless. Managers paste. They do not want a novel. They want the range, the columns, and a total they can eyeball.

Subject line

Harbour orders Mon 20–Sun 26 Oct — 142 orders, £18,410

If the range is in the subject, they do not have to ask whether today is included.

The result they can paste

SELECT order_id, order_date, customer_id, total_amount, status
FROM Orders
WHERE order_date >= '2026-10-20'
  AND order_date <  '2026-10-27'
ORDER BY order_date, order_id;

Headers match the sheet. No SELECT *. Ordered so two people get the same first row.

The check total

SELECT COUNT(*) AS orders, SUM(total_amount) AS revenue
FROM Orders
WHERE order_date >= '2026-10-20'
  AND order_date <  '2026-10-27';

One row. If their pivot is £200 off, you both look at the same number first. Then you argue about cancelled orders, not about the query.