Flag Check

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

Domain

SQL

Difficulty

easy

Problem

Release engineering is auditing the feature flag system before a major rollout. They want to see the overall adoption rate of enabled flags, broken down by owner. For each flag owner, show how many flags they own, the number that are currently enabled, and the average rollout percentage across their flags. Skip any flags with no rollout value on file. Present owners from the highest number of enabled flags to the lowest.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.