코딩테스트 연습(Level.2) / MySQL

코드 입력

SELECT MEMBER_ID,
MEMBER_NAME,
GENDER,
DATE_FORMAT(DATE_OF_BIRTH,'%Y-%m-%d') AS DATE_OF_BIRTH 
FROM MEMBER_PROFILE
where Month(DATE_OF_BIRTH) = 3 and TLNO is not null 
and GENDER = "W"
order by MEMBER_ID

코드 입력

SELECT left(product_code,2) as CATEGORY,
count(*) as PRODUCTS from PRODUCT
group by left(product_code,2)
order by product_code

코드 입력

SELECT ANIMAL_TYPE,count(ANIMAL_ID) as count from ANIMAL_INS
WHERE ANIMAL_TYPE='Cat' or ANIMAL_TYPE ='Dog'
group by ANIMAL_TYPE
order by FIELD(ANIMAL_TYPE, 'Cat','Dog')

먼저 조회를 진행 할 때 FIELD를 쓴다.

코드 입력

SELECT MCDP_CD as 진료과코드,count(APNT_NO) as 5월예약건수 from APPOINTMENT
where Month(APNT_YMD) = 5
group by MCDP_CD
order by 5월예약건수, MCDP_CD