MySQL 주간 월간 연간 평균 구하기

주간

SELECT DATE_FORMAT(date,'%Y-%c %u') Month 

, AVG(battery) AVG 

FROM car_date_history 

WHERE DATE BETWEEN DATE_SUB(CURDATE(),INTERVAL 21 DAY) AND CURDATE() AND car_id = 54

GROUP 

BY WEEK(date) 

ORDER 

BY date DESC;

월간

SELECT DATE_FORMAT(date,'%Y-%c') Month 

, AVG(battery) AVG 

FROM car_date_history 

WHERE DATE BETWEEN DATE_SUB(CURDATE(),INTERVAL 90 DAY) AND CURDATE() AND car_id = 54

GROUP 

BY MONTH(date) 

ORDER 

BY date DESC;

년간

SELECT DATE_FORMAT(date,'%Y') year 

, AVG(battery) AVG 

FROM car_date_history 

WHERE DATE BETWEEN DATE_SUB(CURDATE(),INTERVAL 3 YEAR) AND CURDATE() AND car_id = 54

GROUP 

BY YEAR(date) 

ORDER 

BY date DESC;