solana.tps AS solana,

ethereum.tps AS ethereum,

algorand.tps AS algorand,

near.tps AS near,

bsc.tps AS bsc

FROM

SELECT block_timestamp::date as date, count(tx_id) as txs, COUNT(tx_id)/86400 AS tps

FROM solana.core.fact_transactions

WHERE block_timestamp::date >= current_date-90

and succeeded = 'TRUE'

GROUP BY date

) solana

LEFT JOIN

SELECT block_timestamp::date as date,count(tx_hash) as txs, COUNT(tx_hash)/86400 AS tps

FROM ethereum.core.fact_transactions

WHERE block_timestamp::date >= current_date-90

and status='SUCCESS'

--BETWEEN '2022-07-01' AND '2022-07-19')

GROUP BY date

) ethereum

ON (solana.date = ethereum.date)

LEFT JOIN

SELECT block_timestamp::date as date,count(tx_id) as txs, COUNT(tx_id)/86400 AS tps

FROM flipside_prod_db.algorand.transactions

WHERE block_timestamp::date >= current_date-90

--BETWEEN '2022-07-01' AND '2022-07-19')

GROUP BY date

) algorand

ON (solana.date = algorand.date)

LEFT JOIN

SELECT block_timestamp::date as date,count(tx_hash) as txs, COUNT(txn_hash)/86400 AS tps