Level 8 - PrincipalQuery-Based Questionsm1 distributed data architecture
Tenant Checkout Feed in Last 7 Days
Interviewer prompt: tenant_events is sharded by tenant_id. Write SQL to return latest 50 checkout events for tenant 42 from last 7 days with event_id, created_at, payload_size.
Schema Context
tenant_events(event_id, tenant_id, event_type, created_at, payload_size)