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
|
1
2
3
4
5
|
# Write your MySQL query statement below
select product_id
from Products
where low_fats = 'Y'
and recyclable = 'Y'
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 570. Managers with at Least 5 Direct Reports (0) | 2023.05.31 |
|---|---|
| leetcode 584. Find Customer Referee (0) | 2023.05.29 |
| leetcode https://leetcode.com/problems/last-person-to-fit-in-the-bus/ (0) | 2023.04.21 |
| leetcode 1075. Project Employees I (0) | 2023.04.21 |
| leetcode 1934. Confirmation Rate (0) | 2023.04.21 |
댓글