add 1777

fishercoder1534 · fishercoder1534 · commit 4f9ee81babeb · 2024-01-29T17:57:44.000-08:00
diff --git a/database/_1777.sql b/database/_1777.sql
@@ -0,0 +1,10 @@
+-- # Write your MySQL query statement below
+select
+    product_id,
+    max(case when store = 'store1' then price end) as store1,
+    max(case when store = 'store2' then price end) as store2,
+    max(case when store = 'store3' then price end) as store3
+from
+    Products
+group by
+    product_id
