Services With Most Checks in 2025

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

The compliance team wants to find services whose busiest year for health checks is 2026. For every service whose 2026 check count matches or beats every other year on record for that service, show the service name and its 2026 check count. Sort from highest count down, breaking ties alphabetically.

Summary

Last year's most-checked services.

Practice This Problem

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