SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectQuery-Based Questionsm3 partitioning lifecycle

Monthly Partition Revenue by Tenant

Return tenant_id and monthly paid revenue for Jan 2025.

Schema Context

orders(order_id, tenant_id, status, total_amount, created_at) -- partitioned by created_at