SQL Practice Logo

SQLPractice Online

Level 4 - Mid-LevelScenario-Based Questions

Subscription Downgrade Risk

Find active subscriptions likely to downgrade: usage dropped 40% month-over-month for two consecutive months.

Schema Context

subscription_usage(subscription_id, usage_month, usage_units), subscriptions(id, status)