The Cannibalization Report
A hard SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L6
Interview Prompt
A retail marketplace wants a cannibalization read on its newest arrivals, the products whose very first sale landed in the last 9 months, comparing how the whole category was selling in the 30 days before that first sale against the 30 days after. Show the product name, category, the before and after category sales, and the percentage change between them.
Summary
The new product launched. The old one suffered.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision