Oracle Simple & Best Solution
Please upvote if you find it helpful.\n\n\n/* Write your PL/SQL query statement below */\n\n\nSELECT\nproduct_id AS "product_id", \n\'store1\' AS "store", \nsto
# Please upvote if you find it helpful.\n\n```\n/* Write your PL/SQL query statement below */\n\n\nSELECT\nproduct_id AS "product_id", \n\'store1\' AS "store", \nstore1 AS "price"\nFROM products\nWHERE store1 IS NOT null\n\nUNION\n\nSELECT \nproduct_id AS "product_id", \n\'store2\' AS "store", \nstore2 AS "price"\nFROM products\nWHERE store2 IS NOT NULL\n\nUNION\n\nSELECT \nproduct_id AS "product_id", \n\'store3\' AS "store", \nstore3 AS "price"\nFROM products\nWHERE store3 IS NOT NULL;\n```\n\n# If you have any queries, you can ask me.
['MySQL', 'Oracle']