SELECT OrderDate, COUNT(OrderID) AS Orders FROM Sales.SalesOrder WHERE Status = 'Shipped' GROUP BY OrderDate HAVING COUNT(OrderID) > 1 ORDER BY OrderDate DESC;
SELECT OrderDate, COUNT(OrderID) AS Orders FROM Sales.SalesOrder WHERE Status = 'Shipped' GROUP BY OrderDate HAVING COUNT(OrderID) > 1 ORDER BY OrderDate DESC;