SQL · ByteDance · Medium
Write ANSI-compliant SQL for every part below. The evaluation window is fixed at seven days: from 2025-05-26 00:00:00 UTC through 2025-06-01 23:59:59 UTC, inclusive. Schema: Sample data: The sample rows are illustrative only; they are intentionally small and do not necessarily satisfy the threshold conditions. Part A — Rank top bad advertisers An advertiser qualifies as a top bad advertiser when, during the entire seven-day window: its ads collectively receive at least 1,000…
Checking your access…