루루의 우당탕탕 개발 스토리 루루의 우당탕탕 개발 스토리

https://leetcode.com/problems/bank-account-summary-ii/?envType=study-plan&id=sql-i Bank Account Summary II - LeetCode 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 select u.name, tb.sum as balance from (select account, sum(amount) as sum from Transactions group by account having sum(amoun..

https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/?envType=study-plan&id=sql-i Actors and Directors Who Cooperated At Least Three Times - LeetCode 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 select actor_id, director_id from actordirector group by 1,..

https://leetcode.com/problems/duplicate-emails/?envType=study-plan&id=sql-i Duplicate Emails - LeetCode 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 select email as Email from person group by email having count(id) >= 2;

https://leetcode.com/problems/market-analysis-i/ Market Analysis I - LeetCode 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 select u.user_id as buyer_id, u.join_date, IFNULL(tb.number, 0) as orders_in_2019 from (select buyer_id, count(order_id) as number from orders where order_date betwe..

https://leetcode.com/problems/capital-gainloss/?envType=study-plan&id=sql-i Capital Gain/Loss - LeetCode 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 select tb.stock_name, sum(price) as capital_gain_loss from (select stock_name, IF(operation = "Buy" , price*(-1), price) as price from sto..

https://leetcode.com/problems/top-travellers/?envType=study-plan&id=sql-i Top Travellers - LeetCode 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 select u.name, IFNULL(tb.travelled_distance, 0) as travelled_distance from (select user_id, sum(distance) as travelled_distance from rides grou..

https://leetcode.com/problems/find-total-time-spent-by-each-employee/?envType=study-plan&id=sql-i Find Total Time Spent by Each Employee - LeetCode 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 select tb.event_day as day, tb.emp_id as emp_id, sum(diff_time) as total_time from (select even..

일주일 남은 현 시점 17문제가 남았다. 대략 주말을 제외하여 5일동안 푼다고 치면 하루 최소 4문제는 풀어야 하는 셈. 회사 일과 이래저래 핑계로 지난번이랑 다를 바 없는 결론을 맞이했다. 지난번엔 어쨋든 꾸역꾸역 기간안에 마무리하긴 했는데, 이번에는 가능할지 모르겠다. 어쨋든 다시.. 도전..