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 13