Sustainable Low-Fat Recyclable Product Filter

EASY10 pts

A retail catalog system tracks nutritional and packaging compliance flags per product.

Table: products

product_id: unique identifier for each product
low_fats: 'Y' if the product meets low-fat criteria, otherwise 'N'
recyclable: 'Y' if the packaging is recyclable, otherwise 'N'

Task: Return the IDs of products that satisfy both conditions simultaneously:

low_fats = 'Y'
recyclable = 'Y'

Output requirements:

Return exactly one column in this order:
- product_id
Sort results by product_id in ascending order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

products:
| product_id | low_fats | recyclable |
|------------|----------|------------|
| 0          | Y        | N          |
| 1          | Y        | Y          |
| 2          | N        | Y          |
| 3          | Y        | Y          |
| 4          | N        | N          |

Output

[
  {"product_id":1},
  {"product_id":3}
]

Explanation

Only products 1 and 3 have both required compliance flags set to Y.

Example

Input

products:
| product_id | low_fats | recyclable |
|------------|----------|------------|
| 10         | N        | N          |
| 12         | Y        | N          |
| 14         | N        | Y          |

Output

[]

Explanation

No product satisfies both filters, so the result is empty.

Example

Input

products:
| product_id | low_fats | recyclable |
|------------|----------|------------|
| 105        | Y        | Y          |
| 7          | Y        | Y          |
| 51         | N        | Y          |
| 23         | Y        | Y          |

Output

[
  {"product_id":7},
  {"product_id":23},
  {"product_id":105}
]

Explanation

Rows are filtered first, then ordered by product_id ascending.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in products <= 100000
0 <= product_id <= 1000000000
product_id is unique
low_fats is either 'Y' or 'N'
recyclable is either 'Y' or 'N'
Return exactly one column: product_id
Sort results by product_id ascending
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with column: product_id

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

products =

[{"product_id":0,"low_fats":"Y","recyclable":"N"},{"product_id":1,"low_fats":"Y","recyclable":"Y"},{"product_id":2,"low_fats":"N","recyclable":"Y"},{"product_id":3,"low_fats":"Y","recyclable":"Y"},{"product_id":4,"low_fats":"N","recyclable":"N"}]

Sustainable Low-Fat Recyclable Product Filter

Hints

Sustainable Low-Fat Recyclable Product Filter

Hints