with tab1 as (
select
--distinct tx:body:messages[0]:contract as contract,
project_name,--label_type,
min(block_timestamp) as Debut,
count(distinct tx_id) as Transactions,
count(distinct tx_sender) as Users
--from terra.core.fact_msg_attributes A
from terra.core.dim_address_labels B
join terra.core.fact_transactions C on address=tx:body:messages[0]:contract
--where ATTRIBUTE_KEY in ('contract','u_contract_address','contract_name',
--'contract_version','contract_addr','contract_address','dao_contract_address','pair_contract_addr','nft_contract')
--and attribute_value not in ('terra1muhks8yr47lwe370wf65xg5dmyykrawqpkljfm39xhkwhf4r7jps0gwl4l','terra1j8hayvehh3yy02c2vtw5fdhz9f4drhtee8p5n5rguvg3nyd6m83qd2y90a','terra1nsuqsk6kh58ulczatwev87ttq2z6r3pusulg9r24mfj2fvtzd4uq3exn26') --avoiding several Astroport contracts
group by 1
)
SELECT
*
from tab1 where debut>=CURRENT_DATE-INTERVAL '{{N_months}} MONTHS'
order by 2 asc,3 desc