Leetcode Problem 2205. The Number of Users That Are Eligible for Discount

2205. The Number of Users That Are Eligible for Discount

Leetcode Solutions

Start by creating a MySQL function getUserIDs that accepts three parameters: startDate, endDate, and minAmount.
In the function, write a SQL query that selects the count of distinct user_id from the Purchases table.
Apply a WHERE clause to filter the results based on the time_stamp being between startDate and endDate and the amount being greater than or equal to minAmount.
Return the result of the query, which is the count of distinct users who are eligible for a discount.


erDiagram
    Purchases {
        int user_id
        datetime time_stamp
        int amount
        user_id time_stamp PK
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen