count(tx_id) as "Total TX Count",

"Total TX Count"/(1440 * datediff('day','2022-01-01',current_date)) as "Transactions Per Minute (TPM)",

"Total TX Count"/(86400 * datediff('day','2022-01-01',current_date)) as "Transactions Per Second (TPS)"

from flow.core.fact_transactions

where block_timestamp >= '2022-01-01' and block_timestamp::date != CURRENT_DATE and tx_succeeded = 'TRUE'

union ALL

select 'BSC' as chain,

count(tx_hash) as "Total TX Count",

"Total TX Count"/(1440 * datediff('day','2022-01-01',current_date)) as "Transactions Per Minute (TPM)",

"Total TX Count"/(86400 * datediff('day','2022-01-01',current_date)) as "Transactions Per Second (TPS)"

from bsc.core.fact_transactions

where block_timestamp >= '2022-01-01' and block_timestamp::date != CURRENT_DATE and status = 'SUCCESS'

union ALL

select 'Ethereum' as chain,

count(tx_hash) as "Total TX Count",

"Total TX Count"/(1440 * datediff('day','2022-01-01',current_date)) as "Transactions Per Minute (TPM)",

"Total TX Count"/(86400 * datediff('day','2022-01-01',current_date)) as "Transactions Per Second (TPS)"

from ethereum.core.fact_transactions

where block_timestamp >= '2022-01-01' and block_timestamp::date != CURRENT_DATE and status = 'SUCCESS'

union ALL

select 'Avalanche' as chain,

count(tx_hash) as "Total TX Count",

"Total TX Count"/(1440 * datediff('day','2022-01-01',current_date)) as "Transactions Per Minute (TPM)",

"Total TX Count"/(86400 * datediff('day','2022-01-01',current_date)) as "Transactions Per Second (TPS)"

from avalanche.core.fact_transactions