분류 전체보기127 [Tableau] 위도, 경도로 맵 지도 시각화하기 Olist store의 공공데이터를 활용해 위도, 경도로 지도 시각화하기 https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce Brazilian E-Commerce Public Dataset by Olist 100,000 Orders with product, customer and reviews info www.kaggle.com table[olist_customers_dataset] customer_id : 주문 ID customer_unique_id : 고객 ID customer_zip_code_prefix : 고객 우편번호 앞 5자리 📭 customer_city : 고객 주소 (도시) customer_state : 고객 주소 (주) table[o.. 2023. 4. 21. [leetcode] 601. Human Traffic of Stadium / 연속된 숫자 3개 이상 601. Human Traffic of Stadium https://leetcode.com/problems/human-traffic-of-stadium/ Human Traffic of Stadium - LeetCode Can you solve this real interview question? Human Traffic of Stadium - Table: Stadium +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | visit_date | date | | people | int | +---------------+---------+ visit_date leetcode.com Write a.. 2023. 4. 19. [leetcode] 262. Trips and Users / 취소 비율 구하기 262. Trips and Users https://leetcode.com/problems/trips-and-users/ Trips and Users - LeetCode Can you solve this real interview question? Trips and Users - Table: Trips +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | client_id | int | | driver_id | int | | city_id | int | | status | enum | | request_at | leetcode.com The cancellation rate is computed .. 2023. 4. 17. [SQL문법] RANGE BETWEEN AND / UNBOUNDED PRECEDING / FOLLOWING RANGE BETWEEN 과 AND 사이에 사용 UNBOUNDED PRECEDING : 최종 출력될 값의 맨 처음 row의 값 CURRENT ROW : 현재 row UNBONDED FOLLOWING : 최종 출력될 값의 맨 마지막 row의 값 숫자 PRECEDING AND 숫자 FOLLOWING : 숫자만큼 위, 아래 row의 값 ex) between 1 preceding and 1 following -- 바로 위, 아래 row의 값 디폴트는 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW 이다. 리트코드 문제 예제 2023.04.19 - [분류 전체보기] - [leetcode] 601. Human Traffic of Stadium / 연속된 숫자 3개 이상 [l.. 2023. 4. 8. [leetcode] 585. Investments in 2016 / 투자 가치 합 585. Investments in 2016 https://leetcode.com/problems/investments-in-2016/ Investments in 2016 - LeetCode Can you solve this real interview question? Investments in 2016 - 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 Write an SQL query to report the sum of all total investment values in.. 2023. 4. 1. [leetcode] 1907. Count Salary Categories/급여 범주 구하기/CASE WHEN 1907. Count Salary Categories https://leetcode.com/problems/count-salary-categories/ Count Salary Categories - LeetCode Can you solve this real interview question? Count Salary Categories - Table: Accounts +-------------+------+ | Column Name | Type | +-------------+------+ | account_id | int | | income | int | +-------------+------+ account_id is the primary key for this t leetcode.com Write an.. 2023. 3. 31. 이전 1 2 3 4 5 ··· 22 다음
