Solution with unpivot (in postgres equivalent)
Intuition\nLet\'s try something interesting in our solutions :x\n\n# Code\npostgresql []\n-- Write your PostgreSQL query statement below\nselect p.product_id, t
# Intuition\nLet\'s try something interesting in our solutions :x\n\n# Code\n```postgresql []\n-- Write your PostgreSQL query statement below\nselect p.product_id, t.store, t.price from products p\n    cross join lateral (\n        values\n            (store1, \'store1\'),\n            (store2, \'store2\'),\n            (store3, \'store3\')\n    ) as t(price, store)\nwhere t.price is not null\norder by t.store\n```
['PostgreSQL']