SQL · Meta · Medium
Write a single SQL query that, using the calls table, returns how many different caller_id values placed calls to four or more distinct other users within the inclusive interval from 2025-09-15 00:00:00 UTC to 2025-09-21 23:59:59 UTC. The table has the following shape: calls(call_id INT, caller_id INT, callee_id INT, started_at TIMESTAMP, ended_at TIMESTAMP, media_type TEXT, status TEXT) For this calculation: Use only rows where the user appears as caller_id; do not count…
Checking your access…