Loading...

Monthly Deployment Count

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

Domain
SQL
Difficulty
easy
Seniority
junior

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.

Practice This Problem

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