-- Ensure you've run SalesOrdersStructure.sql
-- and SalesOrdersData.sql in the Sample Databases folder
-- in order to run this example. 

SET search_path = SalesOrdersSample;

SELECT Orders.ShipDate, SUM(Orders.OrderTotal) AS SumOfOrderTotal
FROM Orders
WHERE Orders.ShipDate >= DATE '2015-09-01' AND Orders.ShipDate < DATE '2015-10-01'
GROUP BY Orders.ShipDate;
