haju__log

SELECT BOOK_ID,DATE_FORMAT(PUBLISHED_DATE,"%Y-%m-%d") AS PUBLISHED_DATEFROM BOOKWHERE CATEGORY='인문' AND PUBLISHED_DATE LIKE "2021%"ORDER BY PUBLISHED_DATE ASC;  ✅ DATE_FORMAT : 날짜 형식 지정DATE_FORMAT("날짜값"/날짜컬럼,"형식");%Y : 년도 표현 4자리%y : 년도 표현 2자리%M : 달 표현 이름으로 Full Name (January to December)%m : 달 표현을 숫자로  (00 to 12)%d : 일 표현 (01 to 31)

SELECT ANIMAL_TYPE,CASE WHEN NAME IS NULL THEN "No name" ELSE NAMEEND AS "NAME",SEX_UPON_INTAKEFROM ANIMAL_INS;

SELECT COUNT(USER_ID) AS "USERS"FROM USER_INFOWHERE AGE IS NULL;

SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NULLORDER BY ANIMAL_ID ASC;