Second-Highest Active Users by Region | Dataford Interview Questions

Write a SQL query to find the second-highest active user count by region from daily traffic logs.

Calculate total active users for each non-null region across all available log dates. Treat NULL daily counts as contributing no users and return every region tied at the second-highest total.

Output

One row per qualifying region.
Columns: region, total_active_users.
Exclude the highest total and all totals below second place.
Order by region ascending.

Schema

daily_traffic_logs

Column	Type	Description
log_idPK	BIGINT	Unique identifier for the traffic log row
log_date	DATE	Date represented by the traffic log
region	VARCHAR(50)	Geographic region associated with the traffic
active_user_count	INTEGER	Number of active users recorded for the region and date

Your question is Second-Highest Active Users by Region. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem