var query = db.ExecuteQuery<CompanyOrders>(@"
SELECT c.CompanyName,
MIN( o.OrderDate ) AS FirstOrderDate,
MAX( o.OrderDate ) AS LastOrderDate
FROM Customers c
LEFT JOIN Orders o
		ON o.CustomerID = c.CustomerID
GROUP BY c.CustomerID, c.CompanyName
HAVING COUNT(o.OrderDate) > 0
	AND MIN( o.OrderDate ) BETWEEN {0} AND {1}
ORDER BY FirstOrderDate ASC",
new DateTime( 1997, 1, 1 ),
new DateTime( 1997, 12, 31 ) );
