Average Order Value (AOV)

Problem

The business director wants to monitor total shopping cart sizes. Find the average order amount across all transactions. Output aov.

Database Schema

Table: customers

• customer_id (INT): Unique identifier for the customer.
• first_name (VARCHAR): First name.
• last_name (VARCHAR): Last name.

Table: products

• product_id (INT): Unique identifier for the product.
• name (VARCHAR): Product name.
• price (DECIMAL): Product price.
• category (VARCHAR): Product category.

Table: orders

• order_id (INT): Unique identifier for the order.
• customer_id (INT): Foreign key referencing the customer.
• order_date (DATE): Date of the order.
• amount (DECIMAL): Total order amount.

Try It

Hint

Solution