01 – User Session Count
User behavior data table
A session is considered over if a user does not take any action within 10 minutes, or if they do not log in within 5 minutes after logging out. Calculate the number of sessions for each user.
Copy Code
02 – Count the players who score 3 times in a row within 1 minute
Score table of a ball game
Copy Code
03 – Calculate the number of users who are active for three consecutive days within every 7 days
User login data table
Copy code
04 – Calculate the next-day retention rate of new users per day
User login data table
05 – Calculate the increase of stock price on the day when it is higher than those on the previous and next 5 days
Stock price data table
Copy code
Source link
lol
