SQL · Meta · Medium
You are the owner of the "shop visibility" metric on a marketplace. Begin by nailing down a precise definition of that metric, then express the computation in SQL over the trailing seven-day period. Treat 2025-09-01 as the current date, so the measurement window spans 2025-08-26 through 2025-09-01, both endpoints included. Two companion quantities must be defined, each limited to United States users: (A) visibility_rate — the count of distinct US users who were served at…
Checking your access…