[LeetCode][SQL50] #1. Recyclable and Low Fat Products

💻 문제 주소 : Recyclable and Low Fat Products - LeetCode

Recyclable and Low Fat Products - LeetCode

 

💻 문제

Write a solution to find the ids of products that are both low fat and recyclable. Return the result table in any order. The result format is in the following example.

- 저지방이면서 재활용 가능한 상품 ID를 찾으시오. 결과 테이블 순서는 상관 없으며, 포맷은 아래 예시와 같습니다.

Input과 Output 예시

 

💻 코드 및 풀이

select product_id
from products
where low_fats = 'Y' and recyclable = 'Y'