Update README.md

ieshreya · ieshreya · commit 81601033127f · 2024-02-16T17:03:38.000+05:30
diff --git a/README.md b/README.md
@@ -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'
+)
 ```
