The Revenue Cliff

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

Pull a monthly revenue trend showing the month-over-month percentage change. Flag any month where revenue dropped more than 10% from the previous month. Round to 2 decimal places.

Summary

Revenue was climbing. Then it wasn't. Spot the drop.

Practice This Problem

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