Main Body
SELECT
Customer.[Customer ID]
,Customer.[Customer Name]
,Customer.Address1
,Customer.Address2
,Customer.City
,Customer.Region
,Customer.Country
,Customer.[Postal Code]
,Employee.[Employee ID]
,Employee.[Last Name]
,Employee.[First Name]
,Orders.[Order ID]
,Orders.[Customer ID]
,Orders.[Employee ID]
,Orders.[Ship Via]
,Orders.Shipped
,Orders_Detail.[Product ID]
,Orders_Detail.Quantity
,Product.[Product ID]
,Product.[Product Name]
,Product.Color
,Product.Size
,Orders_Detail.[Unit Price] -- In unused formula
FROM
Customer
INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
INNER JOIN Employee ON Orders.[Employee ID] = Employee.[Employee ID]
INNER JOIN [Orders Detail] Orders_Detail ON Orders.[Order ID] = Orders_Detail.[Order ID]
INNER JOIN Product ON Orders_Detail.[Product ID] = Product.[Product ID]
WHERE
not Orders.Shipped
--Orders.[Order Date] in (Date (1998, 04, 12), Date (1998, 04, 30))
ORDER BY
Customer.[Customer Name] ASC -- Group #1
,Orders.[Order ID] ASC -- Group #2