{"id":"ua0_T_tY29NkhuhS6iqXp","shortId":"j1xr","title":"Gaps and Islands: Finding Streaks in SQL","description":"The classic gaps-and-islands problem solved with window functions. Find consecutive date ranges from sparse event data.","contentType":"code","message":null,"creator":null,"tags":["sql","analytics","window-functions","interview-questions"],"createdAt":"2026-04-07T20:33:59.645Z","expiresAt":null,"url":"https://wr.fi/j1xr","provenance":{"tool":"Gemini"},"generation":{"model":"gemini-2.5-pro","provider":"google"},"promptChain":null,"modelInterpretation":null,"cost":null,"version":1,"isOpenEdit":false,"artifacts":[{"filename":"gaps_and_islands.sql","mimeType":"text/x-sql","sizeBytes":2025,"role":null,"url":"https://wr.fi/api/artifacts/f254063916cba9908f99f5dc61d5cf49fbcb5da21d52ef72bcefd00dcca737de"}]}