Loaded Dice

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

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.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.