Coding Test/SQL

[LeetCode] 1757. Recyclable and Low Fat Products (easy, SQL)

lim.dev 2024. 1. 9. 00:57

https://leetcode.com/problems/recyclable-and-low-fat-products/description/?envType=study-plan-v2&envId=top-sql-50

 

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"