The Floor Price

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

Ahead of reserved-instance negotiations, the FinOps team wants to anchor their bid on the smallest real charge each cloud provider has ever billed. The amount column mixes genuine charges with credits and refunds that land as zero or negative, so consider only the actual amounts paid. Show each provider with its lowest charged amount, cheapest first.

Summary

Before the negotiation, find what each provider really charges at its cheapest.

Practice This Problem

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