Snoopy 2. Recyclable and Low Fat Products (1757)
코딩테스트/리트코드 SQL

2. Recyclable and Low Fat Products (1757)

Sooyoon Jeong 2022. 12. 1.

👉https://leetcode.com/problems/recyclable-and-low-fat-products/?envType=study-plan&id=sql-i

 

Recyclable and Low Fat Products - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com


🤔 문제 분석

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

댓글