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)

      1 SELECT product_id,
      2       'store1' AS store,
      3        store1 AS price
      4 FROM Products
      5 WHERE store1 IS NOT NULL
      6 UNION
      7 SELECT product_id, 'store2', store2
      8 FROM Products
      9 WHERE store2 IS NOT NULL
     10 UNION
     11 SELECT product_id, 'store3', store3
     12 FROM Products
     13 WHERE store3 IS NOT NULL
     14