project_type,

avg(Active_days) "Average Active Days"

(

select

tx_signer,

label_type as project_type,

count(distinct date_trunc('day', block_timestamp)) as Active_days

from (

select

t.block_timestamp,

project_name,

label_type,

tx_signer

from

near.core.fact_transactions t

left outer join near.core.dim_address_labels l on t.TX_RECEIVER = l.address

where

block_timestamp<current_date

)

group by 1,2

)

where project_type is not null

group by 1

order by 2 desc

LIMIT 8