Recyclable and Low Fat Products.sql

-- Problem Statement: Write a solution to find the ids of products that are both low fat and recyclable.

-- Given Table: Products
-- 
-- +-------------+---------+
-- | Column Name | Type    |
-- +-------------+---------+
-- | product_id  | int     |
-- | low_fats    | enum    |
-- | recyclable  | enum    |
-- +-------------+---------+
-- product_id is the primary key (column with unique values) for this table.
-- low_fats is an ENUM (category) of type ('Y', 'N') where 'Y' means this product is low fat and 'N' means it is not.
-- recyclable is an ENUM (category) of types ('Y', 'N') where 'Y' means this product is recyclable and 'N' means it is not.
-- 
-- Approach: To find the ids of products that are both low fat and recyclable, we can simply query the product_id from the Products table where low_fats='Y' and recyclable='Y'.
-- 
-- SQL Solution:
SELECT product_id
FROM Products
WHERE low_fats = 'Y'
AND recyclable = 'Y';