SQL · ByteDance · Hard
Two tables describe a publishing platform. creators lists each creator's creator_id, their country, their IANA time zone tz, and their status. posts lists each post's post_id, its author creator_id, the UTC timestamp created_at_utc, and two flags is_test and is_deleted. Write one SQL query (CTEs and window functions are permitted) that, per country, reports how large a fraction of its active creators sharply cut their posting rate recently. A post is valid only when is_test…
Checking your access…