Shadow Spend

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The FinOps team wants a single view of cloud spend that merges the billed cost records with the internal allocation records, counting a line item that appears in both only once. Drop any row with no amount or no region, then report the total spend for each region and service pairing, highest first.

Summary

Region by region. Service by service. Where does the money go?

Practice This Problem

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