This content originally appeared on DEV Community and was authored by Judy
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
Open source SPL source address
This content originally appeared on DEV Community and was authored by Judy
Judy | Sciencx (2024-11-12T02:27:35+00:00) What to use for data analysis programming, SQL, Python, or esProc SPL?. Retrieved from https://www.scien.cx/2024/11/12/what-to-use-for-data-analysis-programming-sql-python-or-esproc-spl/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.