Users with impressions on seven consecutive days
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.
No answer yet. Write the first one; the best answer gets endorsed.
