Customer Order Summary

Problem Statement

Problem Description You are tasked with generating a summary of customer orders. For each order, you need to retrieve the customer's name, the order ID, the date the order was placed, the number of distinct products included in that order, and the total amount of the order. Schema The database consists of five tables. Note that while some tables represent the full e-commerce schema, they may not all be necessary to solve this specific problem. customers customer_id (INT): Unique identifier for the customer. customer_name (VARCHAR): Name of the customer. email (VARCHAR): Email address of the customer. city (VARCHAR): City of the customer. registration_date (DATE): Date the customer registered. categories category_id (INT): Unique identifier for the category. category_name (VARCHAR): Name of the category. parent_category_id (INT): Identifier for the parent category (if any). products product_id (INT): Unique identifier for the product. product_name (VARCHAR): Name of the product. categor