Tag: interview questions
-
Solution StrataScratch Aggregate Listening Data
Interview Question You’re tasked with analyzing a Spotify-like dataset that captures user listening habits. For each user, calculate the total listening time and the count of unique songs they’ve listened to. In the database duration values are displayed in seconds. Round the total listening duration to the nearest whole minute. The output should contain three…