Reference for Question 10

Sales Database:

Customer(custId, lastName, firstName, address, phone, creditLimit)

Order(orderNumber, date, total, custID.

LineItem(orderNumber, itemNumber, qtyOrdereD.

Item(itemNumber, itemName, price)

For the Sales Database in the reference, write the SQL command to show the customer name, customer ID, and number of orders for each customer