-- 일단위 Select DATEPART(dd, order_dt), count(order_no) From 주문테이블 group by DATEPART(dd, order_dt) order by DATEPART(dd, order_dt) -- 주 단위 Select DATEPART(ww, order_dt), count(order_no) From 주문테이블 group by DATEPART(ww, order_dt) order by DATEPART(ww, order_dt) -- 월단위 Select DATEPART(mm, order_dt), count(order_no) From 주문테이블 group by DATEPART(mm, order_dt) order by DATEPART(mm, order_dt) -- 년단위 Sel..