leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1795.sql (269B)
0 SELECT product_id,
1 'store1' AS store,
2 store1 AS price
3 FROM Products
4 WHERE store1 IS NOT NULL
5 UNION
6 SELECT product_id, 'store2', store2
7 FROM Products
8 WHERE store2 IS NOT NULL
9 UNION
10 SELECT product_id, 'store3', store3
11 FROM Products
12 WHERE store3 IS NOT NULL