Recyclable and Low Fat Products - LeetCode
Can you solve this real interview question? Recyclable and Low Fat Products - Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | low_fats | enum | | recyclable | enum | +-------------+---------
leetcode.com
전체 코드
SELECT product_id
FROM Products
WHERE low_fats LIKE "Y"
and recyclable LIKE "Y"
'Coding Test > SQL' 카테고리의 다른 글
[프로그래머스/SQL 고득점 Kit] SELECT ALL SOLVE (1) | 2024.01.10 |
---|---|
[LeetCode] 1683. Invalid Tweets (easy, SQL) (0) | 2024.01.09 |
[LeetCode] 1148. Article Views I (easy, SQL) (1) | 2024.01.09 |
[LeetCode] 595. Big Countries (easy, SQL) (0) | 2024.01.09 |
[LeetCode] 584. Find Customer Referee (easy, SQL) (0) | 2024.01.09 |