분류 전체보기350

• [TIL] 20230102 (월) 나는 오늘 무엇을 했는가? - AIS7 final 중간발표 - 10회차 EDA - 5회차 모델링 나는 오늘 무엇을 느꼈는가? 어제 저녁부터 중간 발표 자료 ppt를 만들기 시작해서 발표 준비할 시간이 부족했는데, 짧은 시간안에 준비한거에 비해서 발표를 잘 해내서 뿌듯했던 것 같다. 총 공부시간 14시간 03분 07초 복습 및 회고/TIL 2023. 1. 2.

• [TIL] 20230101 (일) 나는 오늘 무엇을 했는가? 1. 파이널 프로젝트 - 5회차 EDA 및 파생변수 생성 - 5회차 모델링 - 10회차 EDA - 중간발표 자료 제작 나는 오늘 무엇을 느꼈는가? TIL을 꾸준히 쓰다가 프로젝트에 치여서 12월 말부터 작성을 못했었다. 새해를 맞이한 기념으로 다시 꾸준히 써보고, 캠프가 얼마남지 않았으니까 잘 마무리 해보자. (새삼.. 퇴사한지도 시간이 꽤 흘렀다는 생각이 든다.) 너무 느슨해질 필요는 없지만, 너무 조급해질 필요도 없는 것 같다. 내 속도에 맞춰서 하나씩 차분히 준비해보자. 총 공부시간 12시간 19분 20초 복습 및 회고/TIL 2023. 1. 1.

• [리트코드/SQL] 30. Duplicate Emalis (182) 👉https://leetcode.com/problems/duplicate-emails/description/ 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 🤔 문제 분석 1) Write an SQL query to report all the duplicate emails. 2) Return the result table in any order. 💡 풀이 select Email FROM Person group by Email ha.. 코딩테스트/리트코드 SQL 2022. 12. 23.

• [리트코드/SQL] 28. Top Travellers (1407) 👉https://leetcode.com/problems/top-travellers/description/ 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 🤔 문제 분석 1) Return the result table ordered by travelled_distance in descending order, 2) if two or more users traveled the same distance, order them by .. 코딩테스트/리트코드 SQL 2022. 12. 23.

• [리트코드/SQL] 27. Capital Gain/Loss(1393) 👉https://leetcode.com/problems/capital-gainloss/description/ 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 🤔 문제 분석 1) Write an SQL query to report the Capital gain/loss for each stock. 2) The Capital gain/loss of a stock is the total gain or loss after buying .. 코딩테스트/리트코드 SQL 2022. 12. 21.

• [리트코드/SQL] 26. Find Total Time Spent by Each Employee (1741) 👉https://leetcode.com/problems/find-total-time-spent-by-each-employee/description/ 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 🤔 문제 분석 1) Write an SQL query to calculate the total time in minutes spent by each employee on each day at the.. 코딩테스트/리트코드 SQL 2022. 12. 21.

• [리트코드/SQL] 25. The Latest Login in 2020 (1890) 👉https://leetcode.com/problems/the-latest-login-in-2020/description/?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 🤔 문제 분석 1) Write an SQL query to report the latest login for all users in the year 2020. 2) Do not include the.. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 24. Game Play Analysis I (511) 👉 https://leetcode.com/problems/game-play-analysis-i/description/?envType=study-plan&id=sql-i Game Play 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 🤔 문제 분석 1) Write an SQL query to report the first login date for each player. 💡 풀이 SELECT player_id, min(event_date) .. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 23. Customer Placing the Largest Number of Orders (586) 👉https://leetcode.com/problems/customer-placing-the-largest-number-of-orders/description/?envType=study-plan&id=sql-i Customer Placing the Largest Number of Orders - 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 🤔 문제 분석 1) Write an SQL query to find the for the customer who has p.. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 22. Find Followers Count (1729) 👉https://leetcode.com/problems/find-followers-count/?envType=study-plan&id=sql-i Find Followers Count - 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 🤔 문제 분석 1) Write an SQL query that will, for each user, return the number of followers. 2) Return the result table ordered by user.. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 21. Daily Leads and Partners (1693) 👉https://leetcode.com/problems/daily-leads-and-partners/description/?envType=study-plan&id=sql-i Daily Leads and Partners - 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 🤔 문제 분석 1) Write an SQL query that will, for each date_id and make_name, return the number of distinct lead_id.. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 20. User Activity for the Past 30 Days I (1141) 👉https://leetcode.com/problems/user-activity-for-the-past-30-days-i/?envType=study-plan&id=sql-i User Activity for the Past 30 Days 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 🤔 문제 분석 1) Write an SQL query to find the daily active user count for a period of 30 days ending 2.. 코딩테스트/리트코드 SQL 2022. 12. 18.