WITH TRANSACTIONS AS (
SELECT COUNT(DISTINCT(TX_HASH))
FROM polygon.core.fact_transactions
WHERE BLOCK_TIMESTAMP::DATE >= '2022-07-01'),
UNIQUE_WALLETS AS (
SELECT COUNT(DISTINCT(FROM_ADDRESS))
FROM polygon.core.fact_transactions
WHERE BLOCK_TIMESTAMP::DATE BETWEEN '2022-07-01' AND CURRENT_DATE-1)
SELECT 'Total number of transactions beginning July 1, 2022' AS type, * FROM TRANSACTIONS
UNION
SELECT 'Total number of unique wallets beginning July 1, 2022' AS type, * FROM UNIQUE_WALLETS