LISTING 2: Test Query

SET STATISTICS TIME ON
SET STATISTICS IO ON
GO
-- TEST QUERY:
SELECT o2.OrderID, CustomerID, OrderDate, ProductID,
 UnitPrice, Quantity
FROM o2 JOIN od2
ON o2.OrderID = od2.OrderID
WHERE CustomerID LIKE 'T%'
AND UnitPrice < 10