This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Feed Engineer at Snap. The product team is building a "latest activity" widget that shows each user's most recent published post on their profile card. You need to write a query that retrieves exactly one post per user -- the one with the most recent created_at timestamp -- so the widget displays current content rather than stale or deleted posts.
You are a Feed Engineer at Snap. The product team is building a "latest activity" widget that shows each user's most recent published post on their profile card. You need to write a query that retrieves exactly one post per user -- the one with the most recent created_at timestamp -- so the widget displays current content rather than stale or deleted posts.