Write a comprehensive SQL query combining customers, orders, and products to show customer spending details.
| customer_name | city | total_orders | total_items | total_spent | avg_order_value | |---------------|------|--------------|-------------|-------------|-----------------| | Rajesh Kumar | Mumbai | 3 | 4 | 83200.0 | 27733.33 | | Sunita Devi | Delhi | 2 | 3 | 83850.0 | 41925.0 | | ... | ... | ... | ... | ... | ... |