The question, and the answer
Which of our packaging costs went up more than ten per cent this year?
Four lines, and cartons moved the most, up fourteen per cent.
Cartons
14%
Board
13%
Pallets
12%
Film
11%
The answer arrives as a chart and a table. No dashboard to build, and no analyst in the queue.
The query, and where the numbers came from
SELECT supplier,
unit,
round((max(price) - min(price)) / min(price), 3) AS rise
FROM purchasing.price_history
WHERE year = 2026
GROUP BY supplier, unit
HAVING rise > 0.10
ORDER BY rise DESC
Written by the agent, run against your warehouse. The prompt, the query, the rows and the cost of the answer are all recorded, so any figure in this page can be checked later.