Longest Consecutive Login Streak for Each User | DB Fiddle

CREATE TABLE UserLogins (
    user_id INT,
    login_date DATE
);

INSERT INTO UserLogins (user_id, login_date) VALUES
(1, '2023-01-01'),
(1, '2023-01-02'),
(1, '2023-01-03'),
(1, '2023-01-04'),
(1, '2023-01-06'),
(1, '2023-01-07'),
(1, '2023-01-08'),
(2, '2023-01-01'),
(2, '2023-01-02'),
(2, '2023-01-04'),
(2, '2023-01-05'),
(2, '2023-01-06');

-- Write an SQL query to find the longest consecutive login streak (number of consecutive days a user has logged in) for each user.

-- Write your query below