Debug Unnecessary ORDER BY in Subquery

Fix query shape issue: SELECT * FROM (SELECT * FROM orders ORDER BY created_at DESC) t WHERE t.status = 'PAID' LIMIT 100;

orders(order_id, status, created_at)