gistfile1.sql

select distinct
sum(FilteredOrders.Total * FilteredOrders.Quantity),
FilteredOrders.Date,
FilteredOrders.ItemID,
FilteredOrders.Name,
FilteredOrders.Quantity,
FilteredOrders.Total
from
(select cast(OrderDate as date) as Date,
OrderItems.ItemID,
OrderItems.Name,
OrderItems.Quantity,
(OrderItems.Price * OrderItems.Quantity) as Total
from OrderItems
inner join Orders on OrderItems.OrderID = Orders.OrderID
where cast(OrderDate as date) >= '2011-01-01' and cast(OrderDate as date) <= '2011-02-28') as FilteredOrders
order by FilteredOrders.Date;