fork download
  1. INSERT INTO login_activity (user_id, login_date) VALUES
  2. -- User 1 (3-day streak + break + 2-day streak)
  3. (1, '2024-01-01'),
  4. (1, '2024-01-02'),
  5. (1, '2024-01-03'),
  6. (1, '2024-01-05'),
  7. (1, '2024-01-06'),
  8.  
  9. -- User 2 (4-day streak)
  10. (2, '2024-02-10'),
  11. (2, '2024-02-11'),
  12. (2, '2024-02-12'),
  13. (2, '2024-02-13'),
  14.  
  15. -- User 3 (no valid streak)
  16. (3, '2024-03-01'),
  17. (3, '2024-03-03'),
  18.  
  19. -- User 4 (exactly 3-day streak)
  20. (4, '2024-04-20'),
  21. (4, '2024-04-21'),
  22. (4, '2024-04-22');
  23.  
Success #stdin #stdout #stderr 0s 5316KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Error: near line 1: no such table: login_activity