# 1777. 每家商店的产品价格
# https://leetcode.cn/problems/products-price-for-each-store/

# SQL架构
Create table If Not Exists Products (product_id int, store ENUM('store1', 'store2', 'store3'), price int);
Truncate table Products;
insert into Products (product_id, store, price) values ('0', 'store1', '95');
insert into Products (product_id, store, price) values ('0', 'store3', '105');
insert into Products (product_id, store, price) values ('0', 'store2', '100');
insert into Products (product_id, store, price) values ('1', 'store1', '70');
insert into Products (product_id, store, price) values ('1', 'store3', '80');

# Write your MySQL query statement below
select
    product_id,
    max(if(store = 'store1', price, null)) as store1,
    max(if(store = 'store2', price, null)) as store2,
    max(if(store = 'store3', price, null)) as store3
from
    Products
group by
    product_id;

# clean-up
drop table Products;