[LeetCode] 1164. Product Price at a Given Date

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

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
WHERE product_id NOT IN (SELECT product_id
                         FROM Products
                         WHERE change_date <= '2019-08-16')