Example question: How can I calculate the average revenue per customer from the 'orders' and 'customers' tables?
Response: To calculate the average revenue per customer, you can join the 'orders' and 'customers' tables using the customer ID and calculate the average revenue using the following SQL query: SELECT AVG(total_amount) as average_revenue_per_customer FROM orders JOIN customers ON orders.customer_id = customers.id;
