A popular game streaming service wants insight into user engagement on their platform. They will analyze both short and long streams and determine how user engagement varies between them.
The result should have the following columns: username | total_streams | avg_stream_duration | total viewers | uniq viewers_gt_30min | uniq_viewers_Ite_30min.
⚫ username - the streamer username
⚫total_streams - the total number of streams for a specific streamer
avg_stream_duration - the average duration of the stream for a specific streamer, rounded up to the nearest integer, l.e. 20.01 and 20.99 round to 21.
⚫ total viewers - the total number of viewer streams for a specific streamer
⚫ uniq_viewers_gt_30min- the total number of unique viewers who watched streams for more than 30 minutes • uniq_viewers_Ite_30min - the total number of unique viewers who watched streams for less than or equal to 30 minutes
The results should be sorted in ascending order by username.
Note:
Each stream might have non-unique viewers, e.g. when someone watches the same stream on multiple devices.