SQL · Pinterest · Medium
We have two tables: pins impressions pin_id is the primary key of pins. A pin qualifies as fresh if it receives at least two total impressions within the seven‑day window that starts on its created_date (inclusive). In other words, date_impression must satisfy BETWEEN created_date AND created_date + 6. We are asked to calculate the percentage of distinct users who viewed at least one fresh pin, expressed on a 0–100 scale and rounded to two decimal places. Return a single…
Checking your access…