코드 및 쿼리문/SQL 공부

문제코드SELECT BOOK_ID, AUTHOR_NAME, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATEFROM BOOK JOIN AUTHOR ON BOOK.AUTHOR_ID = AUTHOR.AUTHOR_IDWHERE CATEGORY = '경제'ORDER BY 3; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/144854

문제코드SELECT CAR_TYPE, COUNT(CAR_ID) AS CARSFROM CAR_RENTAL_COMPANY_CARWHERE OPTIONS LIKE '%시트%'GROUP BY CAR_TYPEORDER BY CAR_TYPE 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/151137

문제코드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