목록리트코드 (9)
On the journey of
1. https://leetcode.com/problems/immediate-food-delivery-ii/ 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 문제 자체는 그리 어렵지 않은데, Round 함수를 쓸 때 Round 함수 안의 변수에 case 및 쿼리문 일체를 쓸 줄 알아야 했다. with base_table as ( select *, rank() ..
1. https://leetcode.com/problems/managers-with-at-least-5-direct-reports/ 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 Q. 아래와 같은 테이블이 있다고 하자. Write a solution to find managers with at least five direct reports. Return th..
1. Students and Examinations - https://leetcode.com/problems/students-and-examinations/ Students and Examinations - LeetCode Can you solve this real interview question? Students and Examinations - Table: Students +---------------+---------+ | Column Name | Type | +---------------+---------+ | student_id | int | | student_name | varchar | +---------------+---------+ student_id is leetcode.com Q. ..
1683. Invalid Tweets https://leetcode.com/problems/invalid-tweets/ Invalid Tweets - LeetCode Can you solve this real interview question? Invalid Tweets - Table: Tweets +----------------+---------+ | Column Name | Type | +----------------+---------+ | tweet_id | int | | content | varchar | +----------------+---------+ tweet_id is the primary key (c leetcode.com Q. Write a solution to find the IDs..