Problem

You are given two tables: orders and shipments. The orders table contains customer purchase orders. The shipments table logs shipments dispatched for these orders. Each order is expected to have one shipment if fulfilled.

Write a 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 such unshipped orders.

Table Structure

Table Name: orders

Table Name: shipments

| Column | Type | Description | | order_id | INT | FK for orders.order_id | | shipped_date | DATE | Date when order was shipped |

Answer Structure

The answer should include the customer's name and the count of unshipped orders.