leetcode

Solution 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