← Questions

Users with impressions on seven consecutive days

0
AirbnbCodingLast asked Sep 2026

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.

Write and test your solution herePython in your browser, the question's tests level by level, saved for you.Sign in to start coding