1.
Answer:
SELECT BOOK_ID, DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d')
FROM BOOK
WHERE CATEGORY = '인문'
and PUBLISHED_DATE like '2021%'
;
Code:
https://hyunalee.tistory.com/11
[SQL] 연산자
WHERE 절 연산자 연산자 설명 = 같음 같지 않음 != 같지 않음 보다 크지 않음 BETWEEN지정된 두 값 사이에 있음 IS NULLNULL 값임 연산자 호환성연산자 중 와 !=는 같은 의미이며 보다 작지 않음을 의미하
hyunalee.tistory.com
참고 자료 사이트
2.
code:
SELECT ROUND(AVG(DAILY_FEE),0) AS AVERAGE_FEE
FROM CAR_RENTAL_COMPANY_CAR
GROUP BY CAR_TYPE HAVING CAR_TYPE = 'SUV'
Group by: GROUP BY 는 같은 값을 가진 행끼리 하나의 그룹으로 뭉쳐줌
3.
code:
SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_FORMAT(DATE_OF_BIRTH,'%y-%m-%d') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE TLNO IS NOT NULL
ORDER BY MEMBER_ID
Answer:
SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE DATE_FORMAT(DATE_OF_BIRTH, '%m') = 3
AND TLNO IS NOT NULL AND GENDER = 'W'
ORDER BY MEMBER_ID