오늘도 배운다

최근 Windows 11로 넘어갔다가 장렬히 망했습니다. 컴퓨터 포맷 후 다시 데이터 분석용 환경을 구축한 과정을 공유합니다. 시작하기 전 그래픽 카드 등 하드웨어 적합하며 TensorFlow GPU 2.5 버전을 사용한다는 전제로 진행했습니다. 목표 TensorFlow GPU 2.5 버전 설치 TF GPU 2.5 사용을 위해 필요한 CUDA 11.2, cuDNN 설치 TF GPU 2.5를 사용할 환경 생성 아나콘다 설치 바로 드가입시다. 아나콘다 설치 아나콘다 다운로드 홈페이지 바로가기 - Anaconda Distribution Anaconda | Anaconda Distribution Anaconda's open-source Distribution is the easiest way to perform..

문제 source: LeetCode The cancellation rate is computed by dividing the number of canceled (by client or driver) requests with unbanned users by the total number of requests with unbanned users on that day. Write a SQL query to find the cancellation rate of requests with unbanned users (both client and driver must not be banned) each day between "2013-10-01" and "2013-10-03". Round Cancellation Ra..

문제 source: LeetCode Write an SQL query to report the names of all the salespersons who did not have any orders related to the company with the name "RED". Return the result table in any order. 제출답안(MySQL) WITH red_sp AS ( SELECT sales_id FROM orders WHERE com_id = (SELECT com_id FROM company WHERE name ='RED') ) SELECT name FROM salesperson WHERE sales_id NOT IN (SELECT sales_id FROM red_sp) 문제 ..

문제 source: LeetCode Write an SQL query to report the patient_id, patient_name and conditions of the patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix. Return the result table in any order. 제출답안(MySQL) SELECT patient_id, patient_name, conditions FROM patients WHERE conditions REGEXP'^DIAB1|.* DIAB1|DIAB1$' 문제 바로가기(MySQL)

문제 source: LeetCode Write an SQL query to report the Capital gain/loss for each stock. The Capital gain/loss of a stock is the total gain or loss after buying and selling the stock one or many times. Return the result table in any order. 제출답안(MySQL) WITH ledger AS( SELECT stock_name, CASE WHEN operation = 'Buy' THEN price*(-1) ELSE price END AS balance FROM stocks) SELECT stock_name, SUM(balance..

문제 source: LeetCode Write an SQL query to swap the seat id of every two consecutive students. If the number of students is odd, the id of the last student is not swapped. Return the result table ordered by id in ascending order. 제출답안(MySQL) SELECT ROW_NUMBER() OVER (ORDER BY FLOOR((id+1)/2), MOD(id, 2)) AS id, student FROM seat 풀이(MySQL) 더보기 홀수, 짝수 id 한 쌍 씩 구분 / 쌍 내에서 짝수를 구분할 수 있는 가상의 칼럼 생성 FLOO..

문제 source: LeetCode Write an SQL query to find for each user, the join date and the number of orders they made as a buyer in 2019. Return the result table in any order. 제출답안(MySQL) WITH buyer_2019 AS( SELECT buyer_id, COUNT(order_id) AS orders_in_2019 FROM orders WHERE YEAR(order_date) = 2019 GROUP BY buyer_id ) SELECT user_id AS buyer_id, join_date, CASE WHEN user_id IN (SELECT buyer_id FROM bu..

문제 source: LeetCode Write an SQL query to find employees who have the highest salary in each of the departments. Return the result table in any order. The query result format is in the following example. 제출답안(MySQL) WITH max_sal_by_dpt AS ( SELECT departmentid, MAX(salary) AS salary FROM employee GROUP BY departmentid ) SELECT d.name AS Department, e.name AS Employee, salary AS Salary FROM emplo..