Recyclable and Low Fat Products
Task: Find the ids of products that are both low fat and recyclable.
Table: Products
+-------------+------------+
| Column Name | Type |
+-------------+------------+
| product_id | INT |
| low_fats | varchar(1) |
| recyclable | varchar(1) |
+-------------+------------+
Input: Products table:
+------------+----------+------------+
| product_id | low_fats | recyclable |
+------------+----------+------------+
| 1 | Y | N |
| 2 | Y | Y |
| 3 | N | Y |
| 4 | Y | Y |
| 5 | N | N |
+------------+----------+------------+
Output:
+------------+
| product_id |
+------------+
| 2 |
| 4 |
+------------+