Расш. возм. SQL. Урок 6. Операторы и функции для работы с датами 4/4

SELECT
    DATE_TRUNC('day', DATE) AS date_month,
    COUNT(id_product) AS cnt
FROM
transactions
GROUP BY
 date_month
ORDER BY date_month