(SELECT SUM("USERS") AS USER FROM

(SELECT COUNT(DISTINCT DELEGATOR_ADDRESS) AS USERS

FROM osmosis.core.fact_staking

WHERE "ACTION" = 'undelegate'

UNION ALL

SELECT COUNT(DISTINCT DELEGATOR_ADDRESS) AS USERS

FROM osmosis.core.fact_staking

WHERE "ACTION" = 'redelegate'

)),

gty AS

SELECT COUNT(DISTINCT DELEGATOR_ADDRESS) AS "NUMBER OF USERS", 'count of delegators' AS activity

FROM osmosis.core.fact_staking

WHERE "ACTION" = 'delegate'

GROUP BY 2

)

SELECT (gty."NUMBER OF USERS" - frt."USER") AS "count of users", 'LOYAL' AS activity

FROM frt

JOIN gty

ON 3 = 3

WHERE activity IS NOT NULL

UNION ALL

SELECT COUNT(DISTINCT DELEGATOR_ADDRESS ) AS USERS, 'count of redelegators' AS activity

FROM osmosis.core.fact_staking

WHERE activity IS NOT NULL AND "ACTION" = 'redelegate'

GROUP BY 2

UNION ALL

SELECT COUNT(DISTINCT DELEGATOR_ADDRESS) AS "NUMBER OF USERS", 'count of undelegators' AS activity