반응형
https://leetcode.com/problems/recyclable-and-low-fat-products/description/
간단 조건있는 select 문제였습니다.
📕 풀이방법
📔 풀이과정
저지방이며 재활용가능한 product_id를 select하면 됩니다.
📕 Code
📔 ANSI SQL
select product_id from products where low_fats = 'Y' and recyclable = 'Y'
*더 나은 내용을 위한 지적, 조언은 언제나 환영합니다.
'SQL' 카테고리의 다른 글
(SQL) - LeetCode (easy) 1873. Calculate Special Bonus (0) | 2024.09.03 |
---|---|
(SQL) - LeetCode (easy) 1789. Primary Department for Each Employee (0) | 2024.07.31 |
(SQL) - LeetCode (easy) 1741. Find Total Time Spent by Each Employee (0) | 2024.07.10 |
(SQL) - LeetCode (easy) 1729. Find Followers Count (0) | 2024.06.23 |
(SQL) - LeetCode (easy) 1693. Daily Leads and Partners (0) | 2024.06.13 |