SELECT ANIMAL_ID,NAME,DATETIME
FROM ANIMAL_INS
ORDER BY NAME,DATETIME DESC
SELECT ANIMAL_ID,NAME
FROM ANIMAL_INS
WHERE UPPER(NAME) LIKE '%EL%'
AND ANIMAL_TYPE='Dog'
ORDER BY NAME;
UPPER(컬럼명) : 데이터를 대문자로 바꿈.
LOWER(컬럼명) : 데이터를 소문자로 바꿈
SELECT COUNT(USER_ID) USERS
FROM USER_INFO
WHERE AGE IS NULL;
SELECT MAX(PRICE) MAX_PRICE
FROM PRODUCT
SELECT ANIMAL_TYPE, COALESCE(NAME,'No name') NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS
COALESCE(NAME,'No name') : NAME이 NULL이면 'No name'으로 출력
SELECT WAREHOUSE_ID, WAREHOUSE_NAME,ADDRESS,COALESCE(FREEZER_YN,'N') FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE ADDRESS LIKE '경기도%'
ORDER BY WAREHOUSE_ID;
SELECT FACTORY_ID,FACTORY_NAME,ADDRESS
FROM FOOD_FACTORY
WHERE ADDRESS LIKE '강원도%'
ORDER BY FACTORY_ID;
SELECT ANIMAL_ID, NAME,
DATE_FORMAT(DATETIME,'%Y-%m-%d') '날짜'
FROM ANIMAL_INS;
SELECT DR_NAME,DR_ID,MCDP_CD, DATE_FORMAT(HIRE_YMD,'%Y-%m-%d') HIRE_YMD
FROM DOCTOR
WHERE MCDP_CD IN ('CS','GS')
ORDER BY HIRE_YMD DESC,DR_NAME
SELECT PRODUCT_ID,PRODUCT_NAME,PRODUCT_CD,CATEGORY, PRICE
FROM FOOD_PRODUCT
ORDER BY PRICE DESC
LIMIT 1;