[프로그래머스] SQL Level 1

문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/59034

SELECT *
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;

문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/132203

SELECT DR_NAME , DR_ID , MCDP_CD , DATE_FORMAT(HIRE_YMD, '%Y-%m-%d') AS HIRE_YMD
FROM DOCTOR
where MCDP_CD = 'CS' OR MCDP_CD = 'GS'
ORDER BY HIRE_YMD desc , DR_NAME asc;

문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/59037

SELECT ANIMAL_ID , NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION not like '%Aged%'
ORDER BY ANIMAL_ID;

문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/59403

SELECT ANIMAL_ID , NAME
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;

문제 링크 : https://school.programmers.co.kr/learn/courses/30/lessons/59035

SELECT NAME , DATETIME
FROM ANIMAL_INS
ORDER BY ANIMAL_ID DESC;