Company: hirevue

Difficulty: medium

Problem Statement

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

More hirevue OA questionsInterview experiences