SQL code to retrieve 2nd order for each customer for each day

• Use a subquery to rank orders for each customer by date

• Filter the results to only include the 2nd order for each customer for each day