Leetcode Problem 1127. User Purchase Platform

1127. User Purchase Platform

Leetcode Solutions

Group the spending data by user_id and spend_date and calculate the total amount spent on mobile and desktop for each user on each date.
Use a CASE statement to determine the platform category ('mobile', 'desktop', or 'both') for each user on each date based on the amounts calculated in step 1.
Create a reference table with all possible combinations of spend_date and platform categories.
Perform a LEFT JOIN between the reference table and the categorized spending data on spend_date and platform.
Group the joined data by spend_date and platform and calculate the total amount spent (total_amount) and the total number of users (total_users) for each combination.
Return the final result set with spend_date, platform, total_amount, and total_users.


erDiagram
    Spending {
        int user_id
        date spend_date
        enum platform
        int amount
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen