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

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문제는 풀어야 하는 셈. 회사 일과 이래저래 핑계로 지난번이랑 다를 바 없는 결론을 맞이했다. 지난번엔 어쨋든 꾸역꾸역 기간안에 마무리하긴 했는데, 이번에는 가능할지 모르겠다. 어쨋든 다시.. 도전..

https://leetcode.com/problems/the-latest-login-in-2020/?envType=study-plan&id=sql-i The Latest Login in 2020 - 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 user_id, max(time_stamp) as last_stamp from logins where date(time_stamp) between '2020-01-01' and '2020-12-31' grou..

https://leetcode.com/problems/game-play-analysis-i/ select player_id, min(event_date) as first_login from activity group by player_id;