The Second Order Chronicles :Find Each Customer’s Second Order Date and Purchase Amount Intermediate

          with second_date as
  (select customerid,
          orderid,
          totalamount,
          orderdate,
          nth_value(orderdate, 2) over (partition by customerid
                                        order by orderdate asc) as secondorderdate
   from orders)
select customerid,
       orderid,
       totalamount,
       secondorderdate
from second_date
where orderdate = secondorderdate;