Company: hirevue
Difficulty: medium
A telecom service system maintains information on mobile users, service packages, mobile connections, monthly service bills, bill transactions, daily service consumption and network zones. For this task only two of those relations matter: Schema mobile_connections — the connection details of each user; every connection belongs to exactly one user. connection_id VARCHAR the connection identifier (unique) user_ref VARCHAR the user that owns this connection daily_service_consumption — one row per day per connection, recording that day’s internet usage. connection_id VARCHAR the connection the usage belongs to internet_usage_mb INTEGER internet data consumed, in MB Task Report the user_ref and the total internet usage in MB for all users who have consumed the highest total internet data across all of their mobile connections. If more than one user_ref shares that same highest total, report all of them, in ascending u