SQL · Meta · Hard
A pixel analytics system records daily signal quality for each advertiser's pixels along with daily ad performance. All timestamps are in UTC. Analyze the 30 dates ending at the newest ds present in pixel_signal_daily; the window is inclusive and spans from max(ds) - 29 through max(ds). The following tables are available: advertisers(advertiser_id BIGINT, vertical STRING, created_at TIMESTAMP) pixels(pixel_id BIGINT, advertiser_id BIGINT, installed_at TIMESTAMP)…
Checking your access…