Problem Statement

Problem Description You are given two tables: orders and shipments . The orders table contains customer purchase records, while the shipments table logs shipments dispatched for these orders. Each order is expected to have one shipment record if it has been successfully fulfilled. Write a SQL query to find all customers who have placed at least one order that has not yet been shipped . Return the customer's name and the count of their unshipped orders. Schema orders Table Column Name Type Description order_id INT Unique ID per order (Primary Key). customer VARCHAR Name of the customer. product VARCHAR Name of the product purchased. shipments Table Column Name Type Description order_id INT ID of the shipped order (Foreign Key to orders.order_id ). shipped_date DATE Date when the order was shipped. Required Output Your query should return a result set with the following columns in this exact order: customer (VARCHAR) - The name of the customer. unshipped_orders_count (INT) - The total nu