Loading Company...
This is a verified interview question from Intuit. Candidates reporting seeing this problem in recent Online Assessments (OAs) and onsite rounds. Mastering "SQL: Online Streaming Service Viewer Engagement Report" covers key patterns like Other.
"### Problem In online streaming services, analyzing viewer engagement is key to content optimization and strategic decisions. A development team is creating a detailed report on viewer engagement for each stream. This report categorizes viewers into three segments: those who watched for less than 15 minutes, 15 to 30 minutes, and more than 30 minutes. Additionally, it will provide the total number of viewers for each stream, offering insights into the stream's overall popularity. Note that durations are in whole minutes, e.g., if a viewer watches for 13 minutes and 59 seconds, ignore the partial minute and use 13 whole minutes. The result should have the following columns: - name - less_than_15_min - 15_to_30_min - more_than_30_min - total_viewers. The results should be sorted in ascending order by name.  "
Join thousands of developers practicing for Intuit.