WITH USDC AS (
SELECT
COUNT(DISTINCT TX_GROUP_ID) AS Number_of_USDC_swaps
FROM algorand.swaps
WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
AND SWAP_FROM_ASSET_ID=31566704
),
USDT AS (
SELECT
COUNT(DISTINCT TX_GROUP_ID) AS Number_of_USDT_swaps
FROM algorand.swaps
WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
AND SWAP_FROM_ASSET_ID=312769
),
STBL AS (
SELECT
COUNT(DISTINCT TX_GROUP_ID) AS Number_of_STBL_swaps
FROM algorand.swaps
WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
AND SWAP_FROM_ASSET_ID=465865291
)
SELECT 'The total number of USDC swaps' as type, Number_of_USDC_swaps FROM USDC
UNION ALL
SELECT 'The total number of STBL swaps' as type, Number_of_STBL_swaps FROM STBL
UNION ALL
SELECT 'The total number of USDT swaps' as type, Number_of_USDT_swaps FROM USDT