SELECT MONTHNAME(block_timestamp) Date, COUNT(DISTINCT address) number_of_transactions
FROM algorand.transaction_participation
WHERE MONTH(block_timestamp) = 1 AND YEAR(block_timestamp) = 2021
GROUP BY MONTHNAME(block_timestamp)
UNION
SELECT MONTHNAME(block_timestamp) Date, COUNT(DISTINCT address) number_of_transactions
FROM algorand.transaction_participation
WHERE MONTH(block_timestamp) = 12 AND YEAR(block_timestamp) = 2021
GROUP BY MONTHNAME(block_timestamp)
UNION
SELECT MONTHNAME(block_timestamp) Date, COUNT(DISTINCT address) number_of_transactions
FROM algorand.transaction_participation
WHERE MONTH(block_timestamp) = 1 AND YEAR(block_timestamp) = 2022
GROUP BY MONTHNAME(block_timestamp)