Product price as of a given date

Table price_changes:

(product_id, change_date) is unique. Before its first change, every product costs 10.

Return the price of every product that appears in the table on 2024-03-15: the new_price of its latest change on or before that date, or 10 if all its changes are later.

Output columns: product_id, price.

CREATE TABLE price_changes (
  product_id int NOT NULL,
  new_price int NOT NULL,
  change_date date NOT NULL,
  PRIMARY KEY (product_id, change_date)
);