How to group by date range in MySQL?

Question

MySQL

Greetings. Tell me how to group by date range in MySQL, for example, we take a date segment of 4 days, and group by it. Now I know how to group by day, month, week using DATE_FORMAT

SELECT DATE_FORMAT(datetime, "%d.%m.%Y") as `date`, `name`, SUM(value) AS `sum_val` FROM `log` GROUP BY `date`,`name`

And how to get a cut is valid from 10/10/2017, to 10/14/2017, from 10/15/2017, to 10/19/2017, etc.

Answer 1

Derive the formula. for example
GROUP BY DATEDIFF(`date`, '2017-10-10') DIV 4