Loading interview...

Chat Activity

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

The community team is evaluating channel health and wants to know which chat channels are active and which are dead weight. For each channel, show the total number of messages, the number of unique senders, and the percentage of messages that have been edited. Round the edited percentage to one decimal place. Only include channels with at least five messages, sorted from most to fewest.

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