Find Users with Seven Consecutive Impression Days

A user is classified as a super user if there exists a stretch of seven calendar days in a row such that the user has one or more impressions on all seven of those dates. The input relation is impressions with the following columns: Column Type Meaning impression_id INTEGER Primary key; unique identifier for the row user_id INTEGER Non-null identifier of the user impression_date DATE Non-null calendar date when the impression occurred Write a single read-only PostgreSQL…