[STUDY_PALN] DAY1

 

 

리트코드 사이트를 보다가 신기한게 있어서 가져왔다.

이제껏 인강 보면서 필요한 문제만 풀어서 몰랐는데 SQL_STUDY PLAN이라는게 있어

오늘부터 진행해볼까 한다! 

SQL - Study Plan - LeetCode

 

 

595. Big Countries

SELECT name, population, area
FROM world
WHERE area >= 3000000
OR population >= 25000000;

1757. Recyclable and Low Fat Products

 

 

SELECT product_id
FROM Products
WHERE low_fats = 'Y'
AND recyclable = 'Y'

584. Find Customer Referee

 

SELECT name
FROM Customer
WHERE referee_id != 2 
OR referee_id is null;

183. Customers Who Never Order

SELECT name as Customers
FROM Customers 
WHERE id not in (SELECT customerId
                FROM orders)