label_type as "Program Type",

count(label_type) as "Count of different Type"

from solana.core.fact_events AS e

inner join solana.core.dim_labels l on e.program_id = l.address

where "DATE"::DATE >= CURRENT_DATE - 180

group by 1,2

order by 1 desc