ResumenVentasDiarias.sql

SELECT OrderDate AS 'Fecha Orden',
    SUM(TotalDue) AS 'Total por día'
    FROM Sales.SalesOrderHeader
    WHERE OrderDate >= '2005-07-01T00:00:00'
        AND OrderDate < '2005-08-01T00:00:00'
    GROUP BY OrderDate
    HAVING SUM(TotalDue) >= 15000;