[성동1기 전Z전능 데이터 분석가] 48일차 - EDA 요일별

# 요일별 출고량
SELECT DAYNAME(ship_date) AS '요일', count(*) FROM analysis group by DAYNAME(ship_date);

# 2020년 월별 출고량
SELECT DAYNAME(ship_date) AS '요일', count(ship_date) FROM analysis where ship_date between '2020-01-01' and '2020-12-31' group by DAYNAME(ship_date);

# 2021년 요일별 remark2 출고량
SELECT DAYNAME(ship_date) AS '요일', remark2, count(remark2) FROM analysis where ship_date between '2021-01-01' and '2021-12-31' group by DAYNAME(ship_date), remark2 order by count(remark2) desc, 1;