SELECT DISTINCT nf_token_id, liquidity_provider

FROM ethereum.uniswapv3.ez_positions

WHERE is_active = TRUE

),

bear_eth_users AS (

SELECT DISTINCT from_address AS user

FROM ethereum.core.fact_transactions

WHERE block_timestamp >= '2022-01-01'

),

inactive_providers AS (

SELECT COUNT(*) AS "Count", 'Inactive' AS "Category"

FROM active_positions

WHERE liquidity_provider NOT IN (SELECT user FROM bear_eth_users)

SELECT "Count", "Category"

FROM inactive_providers

UNION ALL

SELECT ( (SELECT (SELECT COUNT(DISTINCT liquidity_provider) FROM active_positions) - (SELECT "Count" FROM inactive_providers))), 'Active';