David, I made a few changes to my query and looks like I am moving in the
right direction
I have also attached my output.
WITH first_cust_cte AS
(
SELECT min(ord_submitted_date)ord_date
, persistent_key_str
FROM orders
group by persistent_key_str
)
SELECT o.persistent_key_str, o.ord_id
FROM orders o INNER JOIN first_cust_cte c
ON o.persistent_key_str = c.persistent_key_str
WHERE ord_submitted_date = ord_date
<http://postgresql.nabble.com/file/n5828385/First_time_orders.png>
Thanks,
Ron
--
View this message in context: http://postgresql.nabble.com/generating-the-average-6-months-spend-excluding-first-orders-tp5828253p5828385.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.