add 1435

fishercoder1534 · fishercoder1534 · commit a79914e5870d · 2021-01-05T16:43:14.000-08:00
diff --git a/README.md b/README.md
@@ -1093,6 +1093,7 @@ _If you like this project, please leave me a star._ &#9733;
 |1517|[Find Users With Valid E-Mails](https://leetcode.com/problems/find-users-with-valid-e-mails/)|[Solution](../master/database/_1517.sql) || Easy |
 |1511|[Customer Order Frequency](https://leetcode.com/problems/customer-order-frequency/)|[Solution](../master/database/_1511.sql) || Easy |
 |1495|[Friendly Movies Streamed Last Month](https://leetcode.com/problems/friendly-movies-streamed-last-month/)|[Solution](../master/database/_1495.sql) || Easy |
+|1435|[Create a Session Bar Chart](https://leetcode.com/problems/create-a-session-bar-chart/)|[Solution](../master/database/_1435.sql) || Easy |
 |1484|[Group Sold Products By The Date](https://leetcode.com/problems/group-sold-products-by-the-date/)|[Solution](../master/database/_1484.sql) || Easy |
 |1407|[Top Travellers](https://leetcode.com/problems/top-travellers/)|[Solution](../master/database/_1407.sql) || Easy |
 |1384|[Total Sales Amount by Year](https://leetcode.com/problems/total-sales-amount-by-year/)|[Solution](../master/database/_1384.sql) || Hard |
diff --git a/database/_1435.sql b/database/_1435.sql
@@ -0,0 +1,14 @@
+-- # Write your MySQL query statement below
+with groupedBy as (
+    select "[0-5>" as bin, 0 as minDuration, 60*5 as maxDuration
+    union all
+    select "[5-10>" as bin, 60*5 as minDuration, 60*10 as maxDuration
+    union all
+    select "[10-15>" as bin, 60*10 as minDuration, 60*15 as maxDuration
+    union all
+    select "15 or more" as bin, 60*15 as minDuration, 2147483647 as maxDuration
+)
+
+select bin, count(session_id) as total from groupedBy
+left join Sessions on duration >= minDuration and duration < maxDuration
+group by bin;
