List the customer_id and their second order_id of customers who placed more than 10 orders in the last 7 days?

WITH LatestOrders AS (
   SELECT o.*
   FROM       Customer c
   INNER JOIN Order    o ON o.Customer_Id = c.Customer_Id
   WHERE 10 < (SELECT COUNT(*)
               FROM   Order o2
               WHERE  o2.Customer_Id    =  c.Customer_Id
               AND    o2.Order_DateTime <= CURDATE() - 7)
   ORDER BY o.Order_DateTime
   LIMIT 2
)
SELECT *
FROM LatestOrders lo
ORDER BY lo.Order_DateTime DESC
LIMIT 1