Write SQL to answer a business question

Write a SQL query to answer this question.

My tables and key columns:
{{describe_e_g_orders_order_id_customer_id}}

Question: {{plain_english}}

Please:
1. Write the query
2. Explain each major section
3. Note assumptions about the data structure
4. Suggest 2-3 related queries to run next

Copied to clipboard.