SELECT
	COUNT(DISTINCT id_transaction) AS transaction_per_day,
    DATE_TRUNC('day', date) AS trunc_date
FROM
	transactions
GROUP BY
    date;