narayana1208 · August 29, 2015 14:07
diff --git a/gistfile1.sql b/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;
	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;
No results found