Query help

[Anon]

I need some help to do a date query. My table test look like this:

date | score | total

2002-03-10 2 34
2002-03-11 4 5
2002-03-12 2 41
2002-03-13 9 9
2002-03-14 8 8

If I would like to select all rows from 2002-03-11 to 2002-03-13 in one query how should it look?

And if I would like sum of score and total in period from 2002-03-11 to 2002-03-13 in one query how should it look?

Thanks,
Michael

[Anon]

1) select * from table where (date >='2002-03-11' and date<='2002-03-13')