scrata-hivesql
Xzchen555
在读研究生一枚,数据分析小白,喜欢python,希望多多交流
展开
-
stratascratch5 Popularity Percentage
Popularity Percentage Find 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 · 1141 阅读 · 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 · 1380 阅读 · 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 · 255 阅读 · 0 评论