Loading interview...

The Vote Tally

A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
hard

Interview Prompt

Combine purchase rows (product_id = 1001, total_amount >= 0, transaction_date between '2024-01-01' and '2024-04-30') with refund rows (product_id = 1001, total_amount < 0, any date). Per transaction_date in the combined set, SUM(total_amount) as net_revenue. Return transaction_date and net_revenue sorted chronologically.

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