LeetCode SQL 50 Question

[IamShiwangi]

1164. Product Price at a Given Date

[iamAntimPal]

# Write your MySQL query statement below # Write your MySQL query statement below WITH T AS (SELECT DISTINCT product_id FROM Products), P AS ( SELECT product_id, new_price AS price FROM Products WHERE (product_id, change_date) IN ( SELECT product_id, MAX(change_date) AS change_date FROM Products WHERE change_date <= '2019-08-16' GROUP BY 1 ) ) SELECT product_id, IFNULL(price, 10) AS price FROM T LEFT JOIN P USING (product_id); 

for eplanation go on that page
1164. Product Price at a Given Date

[IamShiwangi]

Thank you