SQL · Roblox · Hard
A social platform records user activity in four tables. The users table has one row per account, posts has one row per published post, engagement logs each interaction with a post, and follows stores directed follow relationships. All timestamps are UTC, and a month is defined by DATE_TRUNC('month', created_at). Schemas: Part 1: Influence score for May 2025 For the inclusive date range from 2025-05-01 through 2025-05-31, compute each user's influence score as: $$…
Checking your access…