Hi,

I have a tricky SQL query problem that I'm having probs with.

I have a table which resembles something like this

Date | Price1 | Price2 | Price3
01 Jan 2006 | 100 | 100 | 100
02 Jan 2006 | 100 | 100 | 150
03 Jan 2006 | 100 | 100 | 100
04 Feb 2006 | 115 | 100 | 100
05 Feb 2006 | 115 | 100 | 110
06 Feb 2006 | 115 | 115 | 115
07 Mart 2006 | 115 | 100 | 100
08 Mart 2006 | 100 | 100 | 100
09 Mart 2006 | 100 | 100 | 100

and I want to write a query/view that will return this

Date | Price1 | Price2 | Price3
Jan 300 | 300 | 350
Feb 345 | 315 | 325
Mar 315 | 300 | 300

i want sum using between example:
Between 1.1.2009 and 1.31.2009
how to do this


Thanxs