Company: Flipkart Grid SDEintern_18july
Difficulty: medium
A telecom service system maintains information on mobile users, their mobile connections and the daily service consumption recorded for each connection. Schema mobile_users user_ref INT (PK) user_name VARCHAR(120) mobile_connections connection_ref INT (PK) user_ref INT (FK → mobile_users) daily_service_consumption consumption_ref BIGINT (PK) connection_ref INT (FK → mobile_connections) internet_mb INT Task Display the user_ref and the total internet usage in MB for the users who have consumed the highest total internet data across all of their mobile connections. If more than one user_ref ties for that highest total, display all of them in ascending order of user_ref . Input Format (for the code runner) The three tables are supplied on standard input as plain text: U <user_ref> <user_name> (U lines) C <connection_ref> <user_ref> (C lines) D <consumption_ref> <c