Video streaming trends
Question
Suppose we have a table showing session ids for our video streaming app, along with the associated session duration in minutes.
Table: sessions_info
| session_id | duration_min |
|---|---|
| 123 | 1 |
| 124 | 1 |
| 125 | 4 |
| 126 | 15 |
| 127 | 10 |
| 128 | 12 |
| 129 | 7 |
| 130 | 4 |
| 131 | 3 |
| 132 | 6 |
Using this table, write a SQL query to return a histogram 3 min wide binning the sessions.
You can view/query the table in an interactive SQL fiddle here.