Leetcode Problem 1141. User Activity for the Past 30 Days I

1141. User Activity for the Past 30 Days I

Leetcode Solutions

Select the activity_date and user_id columns from the Activity table.
Apply a WHERE clause to filter records that fall within the 30-day period ending on '2019-07-27'.
Use the DATEDIFF function to calculate the difference in days between '2019-07-27' and the activity_date.
Ensure the difference is between 0 and 29 days (inclusive) to cover the 30-day period.
Group the results by activity_date.
Use the COUNT(DISTINCT user_id) function to count the number of unique active users for each day.
Alias the activity_date as day and the count as active_users in the SELECT statement.

erDiagram
    Activity {
        int user_id
        int session_id
        date activity_date
        enum activity_type
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen