Leetcode Problem 1709. Biggest Window Between Visits

1709. Biggest Window Between Visits

Leetcode Solutions

Use the LEAD function to get the next visit date for each user's visit date, partitioned by user_id and ordered by visit_date.
Use IFNULL to replace null values (which indicate that there is no subsequent visit) with the current date '2021-01-01'.
Calculate the difference in days between each visit date and the next visit date (or the current date if the next visit date is null) using DATEDIFF.
Group the results by user_id and use the MAX function to find the biggest window of days for each user.
Select the user_id and the calculated biggest window as the final output, ordered by user_id.

erDiagram
    UserVisits {
        int user_id
        date visit_date
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen