![mysql](https://habrastorage.org/r/w120/webt/5b/53/d5/5b53d5517cb34636505650.png)
MySQL
- 2 ответа
- 0 вопросов
2
Вклад в тег
SELECT
user_id,
COUNT(1) as count,
MONTH(FROM_UNIXTIME(created_at)) as month
FROM
my_table
GROUP BY
user_id,
MONTH(FROM_UNIXTIME(created_at))