![mysql](https://habrastorage.org/r/w120/webt/5b/53/d5/5b53d5517cb34636505650.png)
MySQL
- 3 ответа
- 0 вопросов
4
Вклад в тег
SELECT
DATE_FORMAT(`start_date`, '%x-%v') weeks,
COUNT(*), DATE_ADD(`start_date`, INTERVAL(2-DAYOFWEEK(`start_date`)) DAY) first_date,
DATE_ADD(`start_date`, INTERVAL(8-DAYOFWEEK(`start_date`)) DAY) last_date
FROM `events` GROUP BY weeks;