일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
- telegram
- SQL
- docker container
- Python
- MySQL
- Airflow
- 그리디
- leetcode
- 데이터 엔지니어
- 프로그래머스
- data_engineer
- datacamp
- BOT
- 2023년 목표
- airflow webserver
- docker
- 백준 온라인 저지
- Spark
- Dynamic Programming
- delete join
- 빅데이터를 지탱하는 기술
- dsf
- Pseudo Lab
- docker image
- terraform
- 백준온라인저지
- airflow architecture
- Data Engineering
- hackerrank
- 알고리즘
- Today
- Total
목록leetcode (19)
Lim Seunghyun Space
문제 출처 https://leetcode.com/problems/reverse-integer/ Reverse Integer - 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 문제 해설 주어진 숫자의 역순을 출력하는 문제 숫자의 역순이 0으로 시작하면 0을 제외한 결과를 반환 예를 들면 -120의 경우 역순은 -012인데 결과가 -012이 아닌 -12이 되어야 한다. 결과의 범위가 singed 32bit 정수 범위에서 벗어나면 0을 반환 문제 풀이 # source..
문제 출처 https://leetcode.com/problems/median-of-two-sorted-arrays/ Median of Two Sorted Arrays - 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 문제 이해 정렬된 두 개의 리스트를 합쳐 중간값을 구하기 나의 풀이 (Python3) import statistics class Solution: def findMedianSortedArrays(self, nums1: List[int], nums2:..
문제 출처 https://leetcode.com/problems/longest-substring-without-repeating-characters/ Longest Substring Without Repeating Characters - 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 문제 이해 문자열 s에 대해서 반복이 없는 가장 긴 부분 문자열의 길이를 구하기 나의 풀이 (Python3) class Solution: def lengthOfLongestSubst..
문제 출처 https://leetcode.com/problems/rising-temperature/ Rising Temperature - 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 나의 풀이(MySQL) SELECT w2.id FROM Weather AS w1 JOIN Weather As w2 ON DATE(w1.recordDate) = DATE_SUB(w2.recordDate, INTERVAL 1 DAY) WHERE w1.temperature < w2.te..
문제 출처 https://leetcode.com/problems/delete-duplicate-emails/ Delete 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 나의 풀이(MySQL) DELETE P1 FROM Person AS P1 JOIN Person AS P2 ON P1.email = P2.email WHERE P1.id > P2.id;
문제 출처 https://leetcode.com/problems/customers-who-never-order/ Customers Who Never Order - 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 나의 풀이 (not in 사용) select c.name as Customers from Customers as c where c.id not in (select distinct(customerId) from Orders) 나의 풀이(not exists 사..
문제 출처 https://leetcode.com/problems/duplicate-emails/ 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(email) > 1;
문제 출처 https://leetcode.com/problems/employees-earning-more-than-their-managers/ Employees Earning More Than Their Managers - 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 emp.name as Employee from Employee as emp join Employee as mgr on emp.managerId = mgr.id where e..
문제 링크 https://leetcode.com/problems/climbing-stairs/ Climbing Stairs - 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 문제 해설 계단의 정상에 도달하려면 n번의 걸음을 해야한다. 매번 1개 혹은 2개의 계단을 오를 수 있다. 얼마나 많은 방법으로 정상에 오를 수 있는가 나의 풀이 (Python3) class Solution: def climbStairs(self, n): if n