> For the complete documentation index, see [llms.txt](https://jaywin.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jaywin.gitbook.io/leetcode/solutions/1164-product-price-at-a-given-date.md).

# 1164. Product Price at a Given Date

<https://leetcode.com/problems/product-price-at-a-given-date>

## Description

Table: `Products`

```
+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| product\_id    | int     |
| new\_price     | int     |
| change\_date   | date    |
+---------------+---------+
(product\_id, change\_date) is the primary key of this table.
Each row of this table indicates that the price of some product was changed to a new price at some date.
```

Write an SQL query to find the prices of all products on **2019-08-16**. Assume the price of all products before any change is **10**.

The query result format is in the following example:

```
Products table:
+------------+-----------+-------------+
| product\_id | new\_price | change\_date |
+------------+-----------+-------------+
| 1          | 20        | 2019-08-14  |
| 2          | 50        | 2019-08-14  |
| 1          | 30        | 2019-08-15  |
| 1          | 35        | 2019-08-16  |
| 2          | 65        | 2019-08-17  |
| 3          | 20        | 2019-08-18  |
+------------+-----------+-------------+
Result table:
+------------+-------+
| product\_id | price |
+------------+-------+
| 2          | 50    |
| 1          | 35    |
| 3          | 10    |
+------------+-------+
```

## ac

```java
```