SELECT
	CAST(weather.date AS date) AS date,
    weather.temp AS temp,
    COUNT(DISTINCT transactions.id_transaction) AS uniq_transactions
FROM
	weather
LEFT JOIN transactions ON transactions.date = weather.date
GROUP BY
	weather.date,
    weather.temp
ORDER BY
	date ASC;