Level 7 - ArchitectQuery-Based Questionsm2 query shape optimization
Semi-Join for Recently Active Products
Return products that had at least one sale in last 14 days. Avoid duplicate products in result.
Schema Context
products(product_id, name), sales(sale_id, product_id, sold_at)