Flag Check
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
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.
Summary
Which flags are actually live?
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