leetcodeSolution to some Leetcode problems written in C++ |
| git clone git://git.dimitrijedobrota.com/leetcode.git |
| Log | Files | Refs | README | LICENSE |
1164.sql (342B)
0 SELECT DISTINCT product_id, 10 AS 'price'
1 FROM Products
2 GROUP BY product_id
3 HAVING MIN(change_date) > "2019-08-16"
4 UNION ALL
5 SELECT product_id, new_price
6 FROM Products
7 WHERE (product_id, change_date) IN (
8 SELECT product_ID, MAX(change_date) as recent_date
9 FROM Products
10 WHERE change_date <= "2019-08-16"
11 GROUP BY product_id
12 )