Back to problems

Basic SQL Exercise + Learning/Skill-Growth Discussion

SQL · Anthropic · Medium

Part A: SQL (basic) Assume there is an events table containing: user_id (string) event_time (timestamp) event_type (string) value (numeric) Write SQL for the requested one or two tasks from the list below: Calculate daily active users (DAU). Find the 95th percentile of value for every event_type. If the database has no built-in P95 function, describe a suitable alternative. Return each user’s earliest event timestamp together with the event_type from that same event. Part B:…

Checking your access…