https://www.codetree.ai/trails/complete/curated-cards/challenge-traveling-salesman-problem/description Code Tree | Learning to Code with ConfidenceA super-comprehensive, meticulously arranged Coding Learning Curriculum engineered by Algorithm Experts composed of former International Olympiad in Informatics (IOI) medalists.www.codetree.ai 코드import sysdef find_route(cur_node, cur_num): global a..

https://www.codetree.ai/trails/complete/curated-cards/test-maximin-of-numbers/description Code Tree | Learning to Code with ConfidenceA super-comprehensive, meticulously arranged Coding Learning Curriculum engineered by Algorithm Experts composed of former International Olympiad in Informatics (IOI) medalists.www.codetree.ai 코드 (백 트래킹)n = int(input())grid = [list(map(int, input().split())) for _..

https://www.codetree.ai/trails/complete/curated-cards/challenge-max-sum-of-numbers/description Code Tree | Learning to Code with ConfidenceA super-comprehensive, meticulously arranged Coding Learning Curriculum engineered by Algorithm Experts composed of former International Olympiad in Informatics (IOI) medalists.www.codetree.ai 코드def back_tracking(cur_num): if cur_num == n: sum_ans.a..

https://school.programmers.co.kr/learn/courses/30/lessons/273712 프로그래머스SW개발자를 위한 평가, 교육, 채용까지 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 코드SELECT ITEM_ID, ITEM_NAME, RARITYFROM ITEM_INFOWHERE ITEM_ID NOT IN (SELECT t1.ITEM_ID FROM ITEM_TREE t1 JOIN ITEM_TREE t2 ON t1.ITEM_ID = t2.PARENT_ITEM_ID)ORDER BY ITEM_ID DESC 쿼리 실행 순서실행 순서SQL 절설명1FROM (ITEM_TREE → t1)ITEM_TREE 테이블을 t1 별칭으로 설정2..

https://school.programmers.co.kr/learn/courses/30/lessons/293259 프로그래머스SW개발자를 위한 평가, 교육, 채용까지 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 코드SELECT ROUND(AVG(IFNULL(LENGTH, 10)), 2) AS AVERAGE_LENGTHFROM FISH_INFO 쿼리 실행 순서실행 순서SQL 절설명1FROM (FISH_INFO)FISH_INFO 테이블에서 데이터를 가져옴2SELECT (IFNULL(LENGTH, 10))LENGTH 값이 NULL이면 10으로 변환3AVG()IFNULL()이 적용된 LENGTH 값들의 평균을 계산4ROUND(AVG(...), 2)평균 값을..

https://school.programmers.co.kr/learn/courses/30/lessons/273710 프로그래머스SW개발자를 위한 평가, 교육, 채용까지 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 코드SELECT i.ITEM_ID, i.ITEM_NAMEFROM ITEM_INFO i JOIN ITEM_TREE t ON i.ITEM_ID = t.ITEM_IDWHERE t.PARENT_ITEM_ID IS NULL 쿼리 실행 순서실행 순서SQL 절설명1FROM (ITEM_TREE)ITEM_TREE 테이블에서 데이터를 가져옴2WHERE (t.PARENT_ITEM_ID IS NULL)PARENT_ITEM_ID가 NULL인 데이터만 필터링3JOIN..

https://school.programmers.co.kr/learn/courses/30/lessons/131117 프로그래머스SW개발자를 위한 평가, 교육, 채용까지 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 코드SELECT p.PRODUCT_ID, p.PRODUCT_NAME, (p.PRICE * o.TOTAL_AMOUNT) TOTAL_SALESFROM FOOD_PRODUCT p JOIN (SELECT PRODUCT_ID, SUM(AMOUNT) TOTAL_AMOUNT FROM FOOD_ORDER WHERE PRODUCE_DATE LIKE '2022-05%' GROUP BY PRODUCT_ID) o ON p.PRODUCT_ID = o.PRODUCT_..

https://school.programmers.co.kr/learn/courses/30/lessons/133027 프로그래머스SW개발자를 위한 평가, 교육, 채용까지 Total Solution을 제공하는 개발자 성장을 위한 베이스캠프programmers.co.kr 코드SELECT h.FLAVORFROM FIRST_HALF h JOIN (SELECT FLAVOR, SUM(TOTAL_ORDER) AS CNT FROM JULY GROUP BY FLAVOR) AS j ON h.FLAVOR = j.FLAVORORDER BY h.TOTAL_ORDER + j.CNT DESCLIMIT 3 쿼리 실행 순서실행 순서 SQL 절 (Clause) 설명1FROM (JULY)JULY 테이블에서 FLAVOR별 SUM(TOTAL_..