CREATE TABLE login_activity (
    user_id INT,
    login_date DATE
);
INSERT INTO login_activity (user_id, login_date) VALUES
-- User 1 (3-day streak + break + 2-day streak)
(1, '2024-01-01'),
(1, '2024-01-02'),
(1, '2024-01-03'),
(1, '2024-01-05'),
(1, '2024-01-06'),
 
-- User 2 (4-day streak)
(2, '2024-02-10'),
(2, '2024-02-11'),
(2, '2024-02-12'),
(2, '2024-02-13'),
 
-- User 3 (no valid streak)
(3, '2024-03-01'),
(3, '2024-03-03'),
 
-- User 4 (exactly 3-day streak)
(4, '2024-04-20'),
(4, '2024-04-21'),
(4, '2024-04-22');
 

Q1JFQVRFIFRBQkxFIGxvZ2luX2FjdGl2aXR5ICgKICAgIHVzZXJfaWQgSU5ULAogICAgbG9naW5fZGF0ZSBEQVRFCik7CklOU0VSVCBJTlRPIGxvZ2luX2FjdGl2aXR5ICh1c2VyX2lkLCBsb2dpbl9kYXRlKSBWQUxVRVMKLS0gVXNlciAxICgzLWRheSBzdHJlYWsgKyBicmVhayArIDItZGF5IHN0cmVhaykKKDEsICcyMDI0LTAxLTAxJyksCigxLCAnMjAyNC0wMS0wMicpLAooMSwgJzIwMjQtMDEtMDMnKSwKKDEsICcyMDI0LTAxLTA1JyksCigxLCAnMjAyNC0wMS0wNicpLAoKLS0gVXNlciAyICg0LWRheSBzdHJlYWspCigyLCAnMjAyNC0wMi0xMCcpLAooMiwgJzIwMjQtMDItMTEnKSwKKDIsICcyMDI0LTAyLTEyJyksCigyLCAnMjAyNC0wMi0xMycpLAoKLS0gVXNlciAzIChubyB2YWxpZCBzdHJlYWspCigzLCAnMjAyNC0wMy0wMScpLAooMywgJzIwMjQtMDMtMDMnKSwKCi0tIFVzZXIgNCAoZXhhY3RseSAzLWRheSBzdHJlYWspCig0LCAnMjAyNC0wNC0yMCcpLAooNCwgJzIwMjQtMDQtMjEnKSwKKDQsICcyMDI0LTA0LTIyJyk7Cg==