Loading interview...

Department Spend Difference

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

Interview Prompt

HR is benchmarking compensation across teams. Calculate the absolute difference between the highest transaction total amount from engineering department users and the highest from marketing department users. Use employee metrics for department info.

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