Re: generating the average 6 months spend excluding first orders

David,

Please I need your help on getting the first time buyer.

I am using the following query but I am getting incorrect results


with cte as
(select *,
        row_number() OVER( partition by persistent_key_str order by ord_submitted_date) RN
        from orders )
select *
from cte where rn = 1

When you use this persistent_key_str = '01000217334' I get incorrect results.

How can I resolve this?