MySQL 실습 | Recyclable and Low Fat Products

문제 1.  Recyclable and Low Fat Products

Write a solution to find the ids of products that are both low fat and recyclable.
Return the result table in any order. 

The result format is in the following example.

Example 1:

Input: 
Products table:
+-------------+----------+------------+
| product_id  | low_fats | recyclable |
+-------------+----------+------------+
| 0           | Y        | N          |
| 1           | Y        | Y          |
| 2           | N        | Y          |
| 3           | Y        | Y          |
| 4           | N        | N          |
+-------------+----------+------------+
Output: 
+-------------+
| product_id  |
+-------------+
| 1           |
| 3           |
+-------------+
Explanation: Only products 1 and 3 are both low fat and recyclable.

---

💡 문제 풀이 

내 풀이

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