SQL · Meta · Hard
For this question, assume today is fixed at 2025-09-01. You have three PostgreSQL tables: Write a single SQL query that returns exactly one row per UTC calendar date from 2025-08-26 through 2025-09-01 inclusive. The result must contain these columns: date_utc (DATE) calls_initiated (INT) completion_rate (NUMERIC) drop_rate (NUMERIC) median_duration_seconds (NUMERIC) The rules are: A call is eligible only when both the caller and callee are non-employees, meaning…
Checking your access…