DATEPART 문법DATEPART(WEEKDAY, DATE) AS DAY 1: Sun, 2:Mon, 3.Tue~ SELECT DATE, DATEPART(YEAR, DATE) AS 년도, DATEPART(MONTH, DATE) AS 월, DATEPART(DAY, DATE) AS 일, DATEPART(WEEKDAY, DATE) AS 요일숫자, DATEPART(WEEK, DATE) AS 주차, DATEPART(QUARTER, DATE) AS 분기, DATEPART(HOUR, DATE) AS 시간, DATEPART(MINUTE, DATE) AS 분FROM 테이블 T; 1. 요일별 매출 분석SELECT DATEPART(WEEKDAY, DATE) AS D..