Busiest Pipeline Month

A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain
SQL
Difficulty
medium
Seniority
L3

Interview Prompt

The data platform team is planning maintenance windows and wants to avoid the busiest month. Which month of the year had the highest number of pipeline executions? Show the month number and the count.

Summary

One month, more pipeline runs than any other.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write and run your SQL against a real database
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision