문제코드SELECT YEAR(DIFFERENTIATION_DATE) AS YEAR,( SELECT MAX(SIZE_OF_COLONY) FROM ECOLI_DATA WHERE YEAR(DIFFERENTIATION_DATE) = YEAR) - SIZE_OF_COLONY AS YEAR_DEV,IDFROM ECOLI_DATAORDER BY YEAR, YEAR_DEV; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/299310
문제코드SELECT ITEM_INFO.ITEM_ID, ITEM_NAME, RARITYFROM ITEM_INFO JOIN ITEM_TREE ON ITEM_INFO.ITEM_ID = ITEM_TREE.ITEM_IDWHERE PARENT_ITEM_ID IN (SELECT ITEM_ID FROM ITEM_INFO WHERE RARITY = 'RARE')ORDER BY ITEM_INFO.ITEM_ID DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/273711
문제코드SELECT ANIMAL_ID, NAME, DATE_FORMAT(DATETIME, '%Y-%m-%d') AS '날짜'FROM ANIMAL_INSORDER BY ANIMAL_ID; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59414
문제코드SELECT CONCAT(CEIL(MONTH(DIFFERENTIATION_DATE) / 3), 'Q') QUARTER , COUNT(ID) ECOLI_COUNTFROM ECOLI_DATAGROUP BY QUARTERORDER BY QUARTER 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/299308
문제코드SELECT ROUTE, CONCAT(ROUND(SUM(D_BETWEEN_DIST), 1),'km') AS TOTAL_DISTANCE, CONCAT(ROUND(AVG(D_BETWEEN_DIST), 2), 'km') AS AVERAGE_DISTANCEFROM SUBWAY_DISTANCEGROUP BY ROUTEORDER BY ROUND(SUM(D_BETWEEN_DIST), 1) DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/284531
문제코드SELECT CAR_ID, ROUND(AVG(DATEDIFF(END_DATE, START_DATE)+1),1) AS AVERAGE_DURATIONFROM CAR_RENTAL_COMPANY_RENTAL_HISTORYGROUP BY CAR_IDHAVING AVG(DATEDIFF(END_DATE, START_DATE)+1)>=7ORDER BY AVERAGE_DURATION DESC, CAR_ID DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/157342
문제코드SELECT COUNT(TIME) AS FISH_COUNTFROM FISH_INFO JOIN FISH_NAME_INFO ON FISH_INFO.FISH_TYPE = FISH_NAME_INFO.FISH_TYPEWHERE FISH_NAME = 'BASS' OR FISH_NAME = 'SNAPPER'; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/298518
문제코드SELECT SUM(G.SCORE) AS SCORE, E.EMP_NO, E.EMP_NAME, E.POSITION, E.EMAILFROM HR_EMPLOYEES E JOIN HR_GRADE G ON E.EMP_NO = G.EMP_NOGROUP BY E.EMP_NOORDER BY SCORE DESCLIMIT 1; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/284527
황규진
'코드 및 쿼리문' 카테고리의 글 목록 (6 Page)