Annual Average Value

General

Annual Average Value

Hi All,

Could you please help me in finding "Annual Average Spend" value of a customer?

I have one table called "CUST_SPEND_DETAIL" and structure is like this:

CUST_ID SPEND_AMOUNT FIRST_SPEND_DATE RECENT_SPEND_DATE
1234 $40 2005-08-04 2005-08-04
1234 $30 2007-02-21 2007-02-21
1234 $10 2009-04-10 2009-05-11

4567 $10 2005-06-04 2005-06-04
4567 $90 2009-09-10 2009-09-10
4567 $0 2009-09-29 2009-10-05
4567 $100 2010-02-06 2010-03-06

I have around more than 1million of records in the CUST_SPEND_DETAIL .

Could you please guide how to find the average annual spend value?

Thanks in advance!

Regards,