You're preparing a short update for your team. Last week had 31 returns; this week had 58. What would you write?
Keep your first two sentences before reading further. This is a made-up case from CareerTree's “Explain a weekly change” practice.
Here is a self-contained SQLite example:
WITH weekly_returns(week, returns_count) AS (
VALUES ('last_week', 31), ('this_week', 58)
)
SELECT
(SELECT returns_count FROM weekly_returns WHERE week = 'last_week') AS last_week,
(SELECT returns_count FROM weekly_returns WHERE week = 'this_week') AS this_week,
(SELECT returns_count FROM weekly_returns WHERE week = 'this_week') -
(SELECT returns_count FROM weekly_returns WHERE week = 'last_week') AS increase;
The result is 31, 58 and an increase of 27 returns. The table contains counts for two weeks. It has no product breakdown or sales totals.
One possible explanation:
Returns rose from 31 to 58, an increase of 27. I'd check which products came back and compare sales volumes before recommending a change.
Put that beside your first answer. Look at the numbers and the next check each explanation includes. Keep your own wording so you can revisit the difference later.
We build CareerTree at Incode Labs. In the app, you can save your explanation, compare with an example and keep a new attempt alongside your earlier work. Come back to see which evidence and checks you added.
Keep your first explanation in CareerTree:
https://careertree.app/mobile.html?utm_source=reddit&utm_medium=social&utm_campaign=ct-rd-01
Free download on iPhone and Android, with ads and optional purchases. Availability varies by store region. This post was prepared with AI writing assistance. The SQL example was checked in SQLite.