Mysql基础练习题 1757.可回收且低脂的产品（力扣）

编写解决方案找出既是低脂又是可回收的产品编号。

题目链接：

https://leetcode.cn/problems/recyclable-and-low-fat-products/description/

建表插入数据：

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')

画图分析：

代码实现：

select product_id from products where low_fats = 'Y' and recyclable='Y';