Good day everyone.

Iam having trouble to write a sql statement that gives a average sales
amount for a month for a customer on a invoice table which has this
following fields(not a complete list of fields)

invoice table
1. invid
2. customerid
3. invdate
4. totalamount

Anybody has tried doing this?

Thank.


Regards

James