ToDo_DATA

https://leetcode.com/problems/exchange-seats Exchange Seats - LeetCode Can you solve this real interview question? Exchange Seats - Table: Seat +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | student | varchar | +-------------+---------+ id is the primary key (unique value) column for leetcode.com select case when id = (select max(id) from Seat) and id%2..

https://leetcode.com/problems/human-traffic-of-stadium LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com with base as ( select distinct id, visit_date, people , id - row_number() over (order by id) as rn from Stadium where pe..

https://leetcode.com/problems/consecutive-numbers Consecutive Numbers - LeetCode Can you solve this real interview question? Consecutive Numbers - Table: Logs +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | num | varchar | +-------------+---------+ In SQL, id is the primary key for this table. leetcode.com with base as ( select num , lag(num, 1) over (or..

https://leetcode.com/problems/second-highest-salary Second Highest Salary - LeetCode Can you solve this real interview question? Second Highest Salary - Table: Employee +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | salary | int | +-------------+------+ id is the primary key (column with unique values) leetcode.com with base as( select distinct salary , dense..

https://school.programmers.co.kr/learn/courses/30/lessons/131537 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr with a as ( select sales_date , product_id , user_id , sum(sales_amount) as sales_amount from ONLINE_SALE where year(sales_date) = 2022 and month(sales_date) = 3 group by 1, 2, 3 ) , b as ( select sales_date , product_id ,..

https://school.programmers.co.kr/learn/courses/30/lessons/131530 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr SELECT case when price < 10000 then 0 else (floor(price/10000)*10000) end as price_group , count(distinct product_id) products from product group by 1 order by 1

https://school.programmers.co.kr/learn/courses/30/lessons/131536 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr with base as ( SELECT user_id , product_id , count(distinct ONLINE_SALE_ID) cnt from ONLINE_SALE group by 1, 2 ) select distinct user_id , product_id from base where cnt >= 2 order by 1, 2 desc

https://school.programmers.co.kr/learn/courses/30/lessons/164670 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr -- 코드를 입력하세요 with base as ( select a.user_id , count(distinct b.board_id) cnt from USED_GOODS_USER a join USED_GOODS_BOARD b on a.user_id = b.writer_id group by 1 ) SELECT distinct a.user_id , a.NICKNAME , concat(a.city,' ..