Creatures of Habit

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

We track every cloud cost allocation by team and service, and we're profiling the big teams: the ones that spread spend across more than three different services. For each of those teams, find the service it allocates most often, along with that allocation count.

Summary

Every big team has one service it can't quit.

Practice This Problem

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