Loaded Dice
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
An A/B testing platform picks which feature flag to show by treating each flag's rollout percentage as its weight, so a flag with no rollout set is out of the running. For every flag still in play, report its selection probability (its share of the total rollout) and a cumulative probability that adds up those shares starting from the smallest rollout and climbing to the largest.
Summary
Every flag's rollout is a bet. Map the odds from longest shot to favorite.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision