Case rounds
Atterna Foundations
You can write a query and want to defend the number it gives
Case 2 · Who cut our commission?
Olga Petrova · finance“Somebody must have given sellers a discount on commission. Can you find out who?”
| Week | Take rate | Electronics |
|---|---|---|
| W37 | 12.60% | 35.0% |
| W38 · promo | 11.46% | 47.7% |
Decision memo
No reversal: the mix explains the drop.
Electronics, at 7% commission, went from 35% to 48% of GMV. Beside it: €21,516 of discounts the platform paid.
A sample learner’s call
€19one-timeearly-access price
Get FoundationsTry first, free: Case 1: Bigger baskets?
After it, you can
- Find out what a number actually counts before you repeat it
- Check a claim on the data: confirm it or break it
- Defend the number in a case round
Inside · Two cases of about 27 minutes, three short drills and 41 practice tasks
- Case 2Who cut our commission?
- Case 3Refunds that don’t add up
- Auto-checksEvery query is also run on a second dataset
- Trap drillsCatch a wrong number in SQL, then say the right one
- Practice41 SQL tasks with hints, in your cabinet; they open as you complete Start days
- SandboxYour own queries on the marketplace data, saved