Cloud Cost Breakdown by Provider

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

Domain

SQL

Difficulty

hard

Seniority

mid

Problem

The FinOps team wants a multi-year cost breakdown from 2022 through 2025. For each cost category and year in the allocation records, show the total spend, the spend specifically in the us-east-1 region, and the number of line items, from the highest total spend down.

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.