Level 7 - ArchitectQuery-Based Questionsm2 query shape optimization
EXISTS for Active Customers in Last 30 Days
Return customers who placed at least one order in last 30 days using existence semantics.
Schema Context
customers(customer_id, name), orders(order_id, customer_id, order_date)