Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

31. Green Product Identification (Easy)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Problem Statement

Table: Inventory
Each row in this table represents a unique product, detailing its ID, whether it's organic, and whether its packaging is biodegradable.

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| product_id    | int     |
| organic       | enum    |
| biodegradable | enum    |
+---------------+---------+
product_id is the primary key for this table.
organic is an ENUM of type ('Y', 'N'), where 'Y' indicates the product is organic and 'N' indicates it is not.

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible