Commit1ef0f80

committed

add 1142

1 parentfce162d commit1ef0f80Copy full SHA for 1ef0f80

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1138,6 +1138,7 @@ _If you like this project, please leave me a star._ ★`
`1138`	`1138`	`\|1179\|[Reformat Department Table](https://leetcode.com/problems/reformat-department-table/)\|[Solution](../master/database/_1179.sql)\|\| Easy\|`
`1139`	`1139`	`\|1173\|[Immediate Food Delivery I](https://leetcode.com/problems/immediate-food-delivery-i/)\|[Solution](../master/database/_1173.sql)\|\| Easy\|`
`1140`	`1140`	`\|1148\|[Article Views I](https://leetcode.com/problems/article-views-i/)\|[Solution](../master/database/_1148.sql)\|\| Easy\|`
	`1141`	`+\|1142\|[User Activity for the Past 30 Days II](https://leetcode.com/problems/user-activity-for-the-past-30-days-ii/)\|[Solution](../master/database/_1142.sql)\|\| Easy\|`
`1141`	`1142`	`\|1141\|[User Activity for the Past 30 Days I](https://leetcode.com/problems/user-activity-for-the-past-30-days-i/)\|[Solution](../master/database/_1141.sql)\|\| Easy\|`
`1142`	`1143`	`\|1113\|[Reported Posts](https://leetcode.com/problems/reported-posts/)\|[Solution](../master/database/_1113.sql)\|\| Easy\|`
`1143`	`1144`	`\|1084\|[Sales Analysis III](https://leetcode.com/problems/sales-analysis-iii/)\|[Solution](../master/database/_1084.sql)\|\| Easy\|`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,5 @@`
	`1`	`+--# Write your MySQL query statement below`
	`2`	`+select ifnull(round(count(distinct session_id)/count(distinct user_id),2),0.00)`
	`3`	`+as average_sessions_per_user`
	`4`	`+from Activity`
	`5`	`+where activity_date between'2019-06-28'and'2019-07-27';`

Comments

(0)