{"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,"environment":null,"task":null,"status":null,"acceptance":null,"claim":null,"versionHash":null,"version":1,"lifecycle":{"accessMode":"permanent","visibility":"public","protection":"none","maxRecipientViews":null,"recipientViewsUsed":null,"ownerViewsConsume":false,"writerViewsConsume":false,"expiresAt":null,"deleteTrigger":null,"serverCanRead":true,"researchEligible":true},"tokenEstimate":{"est":563,"method":"wrfi-h1"},"isOpenEdit":false,"artifacts":[{"filename":"gaps_and_islands.sql","mimeType":"text/x-sql","sizeBytes":2025,"tokenEstimate":{"est":563,"method":"wrfi-h1"},"role":null,"url":"https://wr.fi/api/artifacts/f254063916cba9908f99f5dc61d5cf49fbcb5da21d52ef72bcefd00dcca737de"}]}