--What % of the swaps made this week involved $DOGE?
SELECT
'Not-$DOGE Transaction Count' as category,
COUNT(tx_id) as no_of_tx
FROM thorchain.swaps
WHERE date(block_timestamp) > CURRENT_DATE - 7
AND NOT pool_name = 'DOGE.DOGE'
UNION ALL
SELECT
'$DOGE Transaction Count' as category,
COUNT(tx_id) as no_of_tx
FROM thorchain.swaps
WHERE date(block_timestamp) > CURRENT_DATE - 7
AND pool_name = 'DOGE.DOGE'