SQL · Meta · Medium
You are given four PostgreSQL tables: All timestamps are stored in UTC. For this problem, treat “today” as 2025-06-01. The “last 7 days” window is the inclusive UTC interval from 2025-05-26 00:00:00 through 2025-06-01 23:59:59. “Yesterday” means the calendar date 2025-05-31. Q1: Return the distinct user_id values for users who initiated at least one video call during the last 7 days, based on calls.started_at. The result must contain one column named user_id. Q2: Compute the…
Checking your access…