Thirty Days of Shipping

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

For each month, count unique deployments where a deployment is identified by the combination of service name and version. Format months as 'YYYY-MM'. Return the month and the unique deployment count.

Summary

A month in the life of an engineering team, counted one deploy at a time.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.