Loading interview...

Average Compensation by Department and Status

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

Interview Prompt

HR wants the average total compensation by account status. Compensation is the sum of a user's cost allocation amounts. Only include users who have at least one cost allocation. Show account status and average total compensation.

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