목록코딩테스트/SQL (24)
On the journey of
![](http://i1.daumcdn.net/thumb/C150x150.fwebp.q85/?fname=https://blog.kakaocdn.net/dn/zDamO/btsw0jBriXW/9HlsBKOk2JfNMhpqYpwKIK/img.png)
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() ..
![](http://i1.daumcdn.net/thumb/C150x150.fwebp.q85/?fname=https://blog.kakaocdn.net/dn/Q3lK1/btsv927h0eT/fhABpfGKpToMewVrSaqk41/img.png)
지난 주 일요일은 여러 일정이 겹치면서 한 주 쉬어가는 세션이 되었었는데.... 놀랍게도 벌써 8주차란다. 진짜 언비리버블.. 각설하고 시작 1) 1934. https://leetcode.com/problems/confirmation-rate/ 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. The confirmation rate of a user is ..
![](http://i1.daumcdn.net/thumb/C150x150.fwebp.q85/?fname=https://blog.kakaocdn.net/dn/eeLk9m/btsu8mFTAvK/7gi8w0NT8KPsu3ALXzCo51/img.png)
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..
![](http://i1.daumcdn.net/thumb/C150x150.fwebp.q85/?fname=https://blog.kakaocdn.net/dn/bFYfCX/btst6lB0sYw/YEc1zBOgPr5IqyMnfLmpVK/img.png)
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. ..