Business Studies, asked by KiranGill3299, 17 days ago

What would be the average time between orders (TBOs) in weeks

Answers

Answered by mrsanjayyadav3321
0

Explanation:

I've searched all over but cant seem to find how to calculate the average time between orders for each customer. I'm using Oracle SQL Developer. Ive tried using the lag() function with no joy.

Example data below shows a customer bought on 3 separate occasions. The average time between all purchases is 7.5 days ((6+9)/2).

Similar questions