Server Members
ASKED IN INTERVIEWDiscord
Problem Statement
Discord servers display the current number of active members to help communities gauge engagement. Your task is to query the membership data to find out how many people are currently active.
Write an SQL query to count the number of members in server_id 5501 whose status is currently Online.
Rules:
- Only count members for server_id 5501.
- The status must be exactly Online (case-sensitive).
- Output columns: server_id, online_member_count.
- Results must be returned in descending order based on the count.
Table Schema:
- ServerMembers: member_id, server_id, user_id, status (Online, Offline, Idle, DND), joined_at.
Tests your understanding of
Basic SQL, Aggregation and Filtering
Input Tables
ServerMembers
| server_id(INTEGER) | user_id(INTEGER) | status(VARCHAR) |
|---|---|---|
| 5501 | 10 | Online |
| 5501 | 11 | Idle |
| 5502 | 12 | Online |
| 5501 | 13 | Online |
| 5501 | 14 | Offline |
| 5501 | 15 | Online |
| 5503 | 16 | DND |
Expected Output
| server_id(INTEGER) | online_member_count(INTEGER) |
|---|---|
| 5501 | 3 |
Tags
EasyASKED IN INTERVIEWBasic SQLAggregationFiltering
5 min
89%