gistfile1.txt

select distinct 
Orders.Name,
Orders.id as fid,
Orders.Date as filtereddate,

(
	select sum(Orders.Total * Orders.Quantity)
	WHERE id = fid
)

(
	select sum(Orders.Total * Orders.Quantity) 
	where id = fid
)

from Orders

where cast(Orders.Date as date) >= '2011-01-01' and cast (Orders.Date as date) < '2011-01-02'

order by cast(Orders.Date as date);