Sustainable Low-Fat Recyclable Product Filter

Easy

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 1

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 2

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 3

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.

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

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

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

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