The Tag Order

A hard 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
hard
Seniority
L3

Interview Prompt

The release team's failure review works from `deploy_logs`, where deployment outcomes and environment names were written by several different tools. List each failed deployment with its log ID and its environment in lowercase.

Summary

Tags arrived in chaos. The system needs them in line.

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