![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
scrata-hivesql
Xzchen555
在读研究生一枚,数据分析小白,喜欢python,希望多多交流
展开
-
stratascratch5 Popularity Percentage
Popularity PercentageFind the popularity percentage for each user on Facebook. The popularity percentage is defined as the total number of friends the user has divided by the total number of users on the platform, then converted into a percentage by mul.原创 2021-12-14 15:37:13 · 1143 阅读 · 1 评论 -
stratascratch 4 Finding User Purchases
Write a query that'll identify returning active users. A returning active user is a user that has made a second purchase within 7 days of any other of their purchases. Output a list of user_ids of these returning active users.--建表use strata;drop tab.原创 2021-12-13 14:39:19 · 1384 阅读 · 0 评论 -
stratascratch2-Acceptance Rate By Date
What is the overall friend acceptance rate by date? Your output should have the rate of acceptances by the date the request was sent. Order by the earliest date to latest. Assume that each friend request starts by a user sending (i.e., user_id_sender) a f.原创 2021-12-13 13:50:32 · 258 阅读 · 0 评论