Loading...
Active vs Regional User Count
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- junior, mid
Problem
The platform team is doing a quick capacity check. Compare the number of active user accounts against the number of infrastructure nodes deployed in us-east-1. If active accounts outnumber us-east-1 nodes, return 'More active'; otherwise return 'More us-east-1'.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.