Presence vs. Participation

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

Domain

SQL

Difficulty

medium

Seniority

L3

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'.

Summary

Being in the region and being active are two very different things.

Practice This Problem

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