tcv-tclsbc
diff --git a/‎README.md
Lines changed: 24 additions & 0 deletions b/‎README.md
Lines changed: 24 additions & 0 deletions
@@ -402,4 +402,28 @@ WITH cte AS (
 SELECT DISTINCT(num) AS ConsecutiveNums
 FROM cte
 WHERE num = next AND num = prev
+```
+
+
+[1164. Product Price at a Given Date](https://leetcode.com/problems/product-price-at-a-given-date)
+```sql
+SELECT product_id, new_price AS price
+FROM products
+WHERE (product_id, change_date) IN
+(   
+    SELECT product_id, MAX(change_date)
+    FROM products
+    WHERE change_date <= '2019-08-16'
+    GROUP BY product_id
+)
+UNION
+
+SELECT product_id, 10 AS price
+FROM products
+WHEN product_id NOT IN
+(
+  SELECT product_id
+  FROM products
+  WHERE change_date <= '2019-08-16'
+)
 ```