# 1757. 可回收且低脂的产品
# https://leetcode-cn.com/problems/recyclable-and-low-fat-products/

# SQL架构
Create table If Not Exists Products (product_id int, low_fats ENUM('Y', 'N'), recyclable ENUM('Y','N'));
Truncate table Products;
insert into Products (product_id, low_fats, recyclable) values ('0', 'Y', 'N');
insert into Products (product_id, low_fats, recyclable) values ('1', 'Y', 'Y');
insert into Products (product_id, low_fats, recyclable) values ('2', 'N', 'Y');
insert into Products (product_id, low_fats, recyclable) values ('3', 'Y', 'Y');
insert into Products (product_id, low_fats, recyclable) values ('4', 'N', 'N');

# Write your MySQL query statement below
select
    product_id
from
    Products
where
    low_fats = 'Y'
    and recyclable = 'Y';

# clean-up
drop table Products;