Tag: Data Analysis Programming from SQL to SPL

The following is part of the data from the simplified purchases table ‘purchases’ and sales table ‘sales’: sales: purchases: Download test data 1. Calculate the number of weeks each product experienced stock-out It is required to count only the week in which a product becomes stock-out; if a product remains stock-out for multiple consecutive weeks, subsequent weeks are excluded from the count. The approach to solving this problem is as follows: First, treat purchases as inventory increases and sales as inventory decreases. Therefore, we convert the sales quantities to negative numbers. Next, union the two tables and sort by product

The following is part of the data from the simplified user behavior table actions, which records the occurrence time of 9 types of events for each user: Download test data 1.Find users whohave sequentially triggered events e2, e3, e7 Sequential events do not require continuity. First, group the events by user. Then, sort each user’s events by time. Next, loop through each user’s e2 event to search for an e3 event after it. If an e3 is found, search for an e7 event after e3. If an e7 is found, the user is deemed to satisfy the criteria. Let’s look