문제코드SELECT DATE_FORMAT(DATETIME, '%H') AS HOUR, COUNT(ANIMAL_ID) AS COUNTFROM ANIMAL_OUTSWHERE HOUR(DATETIME) BETWEEN 9 AND 19GROUP BY HOURORDER BY HOUR; 출처: 프로그래머스 코딩 테스트 연습,
코드 및 쿼리문
문제코드SELECT ANIMAL_ID, NAME, CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' OR SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O' ELSE 'X' END AS '중성화'FROM ANIMAL_INSORDER BY ANIMAL_ID; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59409
문제코드SELECT ANIMAL_TYPE, COUNT(ANIMAL_ID) AS 'count'FROM ANIMAL_INSGROUP BY ANIMAL_TYPEORDER BY ANIMAL_TYPE; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59040
문제코드SELECT MCDP_CD AS '진료과코드', COUNT(APNT_NO) AS '5월예약건수'FROM APPOINTMENTWHERE DATE_FORMAT(APNT_YMD, '%Y-%m') = '2022-05'GROUP BY MCDP_CDORDER BY 2, 1; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/132202
문제코드SELECT LEFT(PRODUCT_CODE, 2) AS CATEGORY , COUNT(PRODUCT_ID) AS PRODUCTSFROM PRODUCTGROUP BY CATEGORYORDER BY CATEGORY; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/131529
문제코드SELECT COUNT(ANIMAL_ID) AS 'count'FROM ANIMAL_INS 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/59406
문제코드SELECT COUNT(*) AS COUNTFROM ECOLI_DATA AWHERE (GENOTYPE & 2) = 0 AND ((GENOTYPE & 4) = 4 OR (GENOTYPE & 1) = 1); -- XX0X면서 X1XX이거나 XXX1 인가? 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/301646
문제코드SELECT TITLE, B.BOARD_ID, REPLY_ID, R.WRITER_ID, R.CONTENTS, DATE_FORMAT(R.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATEFROM USED_GOODS_BOARD B JOIN USED_GOODS_REPLY R ON B.BOARD_ID = R.BOARD_IDWHERE YEAR(R.CREATED_DATE) = 2022 AND MONTH(B.CREATED_DATE) = 10ORDER BY R.CREATED_DATE ASC, TITLE ASC 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/164673
문제코드SELECT ID,LENGTHFROM FISH_INFOWHERE LENGTH IS NOT NULLORDER BY LENGTH DESC, ID ASC LIMIT 10; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/298517
