← Questions
Users with impressions on seven consecutive days
0
I was asked this
No reports yet. Sign in to say where you were asked it.
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 official answer yet. Write yours on the right and run it.
Nothing published yet.
Write and test your solution herePython in your browser, the question's tests level by level, saved for you.Sign in to start coding
