Sample Query for Raw Cohort Analysis Data

gistfile1.sql

SELECT orders.customerid, 
       orders.transactiondate, 
       orders.transactionamount, 
       cohorts.cohortdate 
FROM   orders 
       JOIN (SELECT customerid, 
                    Min(transactiondate) AS cohortDate 
             FROM   orders 
             GROUP  BY customerid) AS cohorts 
         ON orders.customerid = cohorts.customerid;