Query editor
WITH tx_count AS (SELECT blockchain, CAST(COUNT(*) AS double) AS total_txsFROM evms.transactionsWHERE block_time > NOW() - interval '1' dayGROUP BY 1), inscriptions AS (SELECT blockchain, CAST(COUNT(DISTINCT tx_hash) AS double) AS inscriptionsFROM inscription.allWHERE block_time > NOW() - interval '1' dayGROUP BY 1)SELECT info.name AS blockchain, info.name AS ordering, i.inscriptions/txs.total_txs AS inscriptions_percentageFROM inscriptions iINNER JOIN tx_count txs USING (blockchain)INNER JOIN evms.info info USING (blockchain)WHERE i.inscriptions/txs.total_txs > 0.01ORDER BY 3 DESC