with m1 as (
SELECT
date_trunc('day', block_timestamp) as day,
proposer,
count(*) as count1
FROM flow.core.fact_transactions
GROUP BY 1,2
)
, m2 as (
SELECT
proposer,
avg(count1) as avg_total_transactions
FROM m1
GROUP BY 1
)
SELECT
CASE WHEN avg_total_transactions > 75 then 'Non Real User' ELSE 'Real User' END,
count(*)
FROM m2
GROUP BY 1