Calculating duration between Orders

Hi all,

I have a table with following columns:-

Orderid, Emailaddress, Datecreated, SaleValue

I need to find the duration between new orders to understand how many customers return within 1 week, 2 weeks etc.

Repeat customer need to identify using emailaddress.

Can any one of you help me to write the script to retrieve this info, please?



Please post

  1. Create Sample Data Script

so that we can work on it


1 Like