as (

select project_name, ADDRESS, LABEL

from osmosis.core.dim_labels

where LABEL_TYPE !='operator' group by ADDRESS,LABEL,project_name

select

project_name,

LABEL as Contracts,

count (distinct tx_id)

as tx_ids

from osmosis.core.fact_msg_attributes

join projects

on ADDRESS = ATTRIBUTE_VALUE

where block_timestamp::date >= '2022-05-01'

group by 1,2

order by tx_ids desc

limit 15