Query editor
WITH all AS (SELECT 'Others' AS tx_type, CAST(COUNT(*) AS double) AS txsFROM arbitrum.transactionsWHERE block_time > CAST('2023-12-15 13:00' AS timestamp)AND block_time < CAST('2023-12-15 16:00' AS timestamp)), inscriptions AS (SELECT 'Inscriptions' AS tx_type, CAST(COUNT(DISTINCT tx_hash) AS double) AS txsFROM inscription_arbitrum.allWHERE block_time > CAST('2023-12-15 13:00' AS timestamp)AND block_time < CAST('2023-12-15 16:00' AS timestamp))SELECT a.tx_type, a.txs-i.txs AS txsFROM all a, inscriptions iUNION ALLSELECT tx_type, txsFROM Inscriptions