Commita79914e

committed

add 1435

1 parentbb2c5dc commita79914eCopy full SHA for a79914e

File tree

+15

-0

lines changed

+15

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1093,6 +1093,7 @@ _If you like this project, please leave me a star._ ★`
`1093`	`1093`	`\|1517\|[Find Users With Valid E-Mails](https://leetcode.com/problems/find-users-with-valid-e-mails/)\|[Solution](../master/database/_1517.sql)\|\| Easy\|`
`1094`	`1094`	`\|1511\|[Customer Order Frequency](https://leetcode.com/problems/customer-order-frequency/)\|[Solution](../master/database/_1511.sql)\|\| Easy\|`
`1095`	`1095`	`\|1495\|[Friendly Movies Streamed Last Month](https://leetcode.com/problems/friendly-movies-streamed-last-month/)\|[Solution](../master/database/_1495.sql)\|\| Easy\|`
	`1096`	`+\|1435\|[Create a Session Bar Chart](https://leetcode.com/problems/create-a-session-bar-chart/)\|[Solution](../master/database/_1435.sql)\|\| Easy\|`
`1096`	`1097`	`\|1484\|[Group Sold Products By The Date](https://leetcode.com/problems/group-sold-products-by-the-date/)\|[Solution](../master/database/_1484.sql)\|\| Easy\|`
`1097`	`1098`	`\|1407\|[Top Travellers](https://leetcode.com/problems/top-travellers/)\|[Solution](../master/database/_1407.sql)\|\| Easy\|`
`1098`	`1099`	`\|1384\|[Total Sales Amount by Year](https://leetcode.com/problems/total-sales-amount-by-year/)\|[Solution](../master/database/_1384.sql)\|\| Hard\|`

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,14 @@`
	`1`	`+-- # Write your MySQL query statement below`
	`2`	`+with groupedByas (`
	`3`	`+select"[0-5>"as bin,0as minDuration,60*5as maxDuration`
	`4`	`+union all`
	`5`	`+select"[5-10>"as bin,605as minDuration,6010as maxDuration`
	`6`	`+union all`
	`7`	`+select"[10-15>"as bin,6010as minDuration,6015as maxDuration`
	`8`	`+union all`
	`9`	`+select"15 or more"as bin,60*15as minDuration,2147483647as maxDuration`
	`10`	`+)`
	`11`	`+`
	`12`	`+select bin,count(session_id)as totalfrom groupedBy`
	`13`	`+left join Sessionson duration>= minDurationand duration< maxDuration`
	`14`	`+group by bin;`

Comments

(0)