Collections
Datasets
Tools
CSV to SQL
JSON to SQL
My Books
Change password
Log out
Sign In
Use desktop for interactive SQL sandbox
Settings
Fork this book
Notes
SQL
MySQL - 8.0
Oracle - 21.3.0
PostgreSQL - 17
ERD
Run Code
Read-only book
Fork to Edit
Tip: Press
Alt
+
Enter
to run SQL
SQL Output
Clear
3. Consecutive Login Days
Public
Detect streaks in time-series data using the gaps and islands technique with ROW_NUMBER and date arithmetic.
jrz1977
PostgreSQL
Created Jan 24, 2026
Contents
1
Notes
Notes
2
SQL
SQL
1 SQL
1 Notes
Switch to a SQL tab and press
Alt
+
Enter
to run queries
3. Consecutive Login Days
Updated 1/24/26, 11:25 PM
Notes
SQL
Alt+Enter to run