Prices change over time and orders must be valued at the price in effect when they were placed. Return each order with the price that was current at ordered_at.

Input schema

Example

Constraints

• Use the row with the greatest valid_from that is not after ordered_at
• Orders placed before any price row return null
• Ties on valid_from take the higher price
• Order by order_id