Highest Total Internet Usage Users

Write a SQL query to display the user ID and total internet usage in ME or all users who have consumed the highest total internet data across all her mobile connections. If more than one user has the same highest total internet usage, display those user IDs in ascending order.

Example 1:

Input:mobie_users: [{user_id: 1, email: 'user1@example.com', city: 'New York', signup_time: '2022-01-01'}], dail_service_consumption: [{user_id: 1, connection_id: 1, internet_usage: 100, call_minutes: 10, sms_usage: 5}, {user_id: 1, connection_id: 2, internet_usage: 200, call_minutes: 20, sms_usage: 10}], network_zones: [{zone_id: 1, zone_type: 'A', generation: '4G', signal_location: 'New York'}]

Output:[1]

Example 2:

Input:mobie_users: [{user_id: 1, email: 'user1@example.com', city: 'New York', signup_time: '2022-01-01'}, {user_id: 2, email: 'user2@example.com', city: 'Los Angeles', signup_time: '2022-01-15'}], dail_service_consumption: [{user_id: 1, connection_id: 1, internet_usage: 100, call_minutes: 10, sms_usage: 5}, {user_id: 1, connection_id: 2, internet_usage: 200, call_minutes: 20, sms_usage: 10}, {user_id: 2, connection_id: 1, internet_usage: 300, call_minutes: 30, sms_usage: 15}], network_zones: [{zone_id: 1, zone_type: 'A', generation: '4G', signal_location: 'New York'}, {zone_id: 2, zone_type: 'B', generation: '5G', signal_location: 'Los Angeles'}]

Output:[1, 2]

Constraints:

The mobie_users table stores user details such as user ID, email registered city, and signup time.
The dail_service_consumption table records the daily internet usage, call minutes, and SMS usage for each mobile connection.
Each usage record is linked to the network_zones table, which stores details about the network zone, type, network generation, and signal location.

solution.cpp

Run code to see test results

00:00 / 69:42

Highest Total Internet Usage Users

MediumMed•509 views

Example 1:

Output:[1]