Loading interview...

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
mid

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision