👉https://leetcode.com/problems/recyclable-and-low-fat-products/?envType=study-plan&id=sql-i
🤔 문제 분석
1) Write an SQL query to find the ids of products that are both low fat and recyclable.
💡 풀이
SELECT product_id
FROM Products
WHERE low_fats = "Y" AND recyclable = "Y"
'코딩테스트 > 리트코드 SQL' 카테고리의 다른 글
[리트코드/SQL] 6. Swap Salary (627) (0) | 2022.12.05 |
---|---|
5. Calculate Special Bonus (1873) (0) | 2022.12.01 |
4. Customers Who Never Order (183) (0) | 2022.12.01 |
3. Find Customer Referee (584) (0) | 2022.12.01 |
1. Big Countries (595) (0) | 2022.11.30 |
댓글