Feature Vote Winner
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
We have a feature-voting system where each user splits a single vote equally among all the flags they voted for. Some users abstained (null entries). Calculate the effective vote tally for each flag and find the winner. Include ties. Return the flag name and effective vote total.
Summary
Users voted with their clicks. Who won?
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