Write a SQL query to analyze operational efficiency by joining production, inventory, and shipment data and calculating key performance indicators by region for Ab Inbev Gcc India.
Use all supplied records as one reporting period. Calculate total production, inventory, shipments, shipment rate as a percentage of production, and inventory as a percentage of production.
Output
- One row per region represented in production data.
- Columns:
region, production_units, inventory_units, shipped_units, shipment_rate_pct, and inventory_to_production_pct.
- Treat missing inventory or shipment totals as zero, avoid division by zero, round percentages to two decimals, and order by
shipment_rate_pct descending, then region ascending.
