Quarterly Peak Cloud Costs

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

A cloud service racks up many separate charges each month across providers and regions. For a quarterly cost review, total each service's charges by calendar month, then report its highest monthly total for Q1, Q2, Q3, and Q4 as separate columns, with services listed alphabetically.

Summary

Every quarter has a peak bill.

Practice This Problem

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