WITH stakeTb as (
SELECT
DELEGATOR_ADDRESS as usr,
COUNT(DISTINCT TX_ID) as total_usr
FROM terra.core.ez_staking
GROUP by 1
)
, swapTb as (
SELECT
TRADER as usr,
COUNT(DISTINCT TX_ID) as total_usr
FROM terra.core.ez_swaps
GROUP by 1
)
, governanceTb as (
SELECT
VOTER as usr,
COUNT(DISTINCT TX_ID) as total_usr
FROM terra.core.fact_governance_votes
GROUP by 1
)
, LPerTb as (
SELECT
LIQUIDITY_PROVIDER_ADDRESS as usr,
COUNT(DISTINCT TX_ID) as total_usr
FROM terra.core.fact_lp_actions
GROUP by 1
)
, nftTb as (
SELECT
MINTER as usr,
COUNT(DISTINCT TX_ID) as total_usr
FROM terra.core.fact_nft_mints
GROUP by 1
UNION