Users with impressions on seven consecutive days

0
Remix

From a table of user impressions with dates, find the users who had at least one impression on seven days in a row. Remove duplicate days per user, then use a window function (row number subtracted from the date) to group consecutive days and keep groups of seven or more.

AirbnbCodingLast asked Sep 2026
No answer yet. Write the first one; the best answer gets endorsed.