목록MySQL (8)
On the journey of
[Leetcode] 1174.Immediate food delivery 2 , 619. Biggest Single Number,626.Exchange Seats
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() ..
[Leetcode] 1934.Confirmation Rate, 1193.Monthly Transactions 1, 1729.Find Followers Count
지난 주 일요일은 여러 일정이 겹치면서 한 주 쉬어가는 세션이 되었었는데.... 놀랍게도 벌써 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 ..
[Leetcode]Students & Examinations, Percentage of Users Attended a contest, Product Sales Analysis 3
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. ..
[LeetCode]1661.Average Time of~, 1251.Average Selling Price , 1141. User Activity for the Past 30 Days I
Q. 1661 Average Time of Process per Machine Average Time of Process per Machine - LeetCode Can you solve this real interview question? Average Time of Process per Machine - Table: Activity +----------------+---------+ | Column Name | Type | +----------------+---------+ | machine_id | int | | process_id | int | | activity_type | enum | | timestam leetcode.com Table: Views +---------------+-------..