SQL · Microsoft · Medium
You are given two tables that describe outbound recruiting email and what happened to each message after it left the sender. Emails holds one row per message that was sent; Deliveries holds one row per delivery-status event observed for a message. Every timestamp is in UTC, and for this exercise "today" is 2025-11-15, so the trailing seven-day window runs from 2025-11-09 through 2025-11-15 inclusive. Table definitions: Emails(sent_id INT, message_id TEXT, provider TEXT,…
Checking your access…