The Revenue Cliff

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

We're tracking monthly revenue and need to catch sharp declines. For each month show its revenue and the month-over-month percentage change, and flag any month that fell more than 10% from the previous month.

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 checks it automatically.