Order-Level Request Statistics

We have two tables. orders: order_id is the primary key. requests: Each row in requests connects one request to an order. An order may have zero or more associated requests. Produce a single output row with these two metrics: pct_orders_with_3plus_requests — the share of orders that have at least 3 requests, expressed as a percentage and rounded to 2 decimal places. avg_requests_per_order — the mean number of requests per order, rounded to 2 decimal places. Orders that have…