with activity as (

with table19 as (

with table17 as (

with table11 as (

with table1 as (

with tab1 as (select tx_sender as "Address", count(distinct tx_id) as "TX Count", rank () over (order by "TX Count" desc) as "TX Count Rank"

from terra.core.fact_transactions

group by 1

order by 2 desc),

tab2 as (select tx_sender as "Address", sum(fee) as "TX Fee", rank () over (order by "TX Fee" desc) as "TX Fee Rank"

from terra.core.fact_transactions

where fee_denom='uluna'

group by 1

order by 2 desc)

select tab1."Address" as "Address", "TX Count", "TX Count Rank", "TX Fee", "TX Fee Rank"

from tab1 full outer join tab2 on tab1."Address"=tab2."Address"),

table2 as (

with tab3 as (select tx_sender as "Address", count(distinct block_timestamp::date) as "Active Days",

rank () over (order by "Active Days" desc) as "Active Days Rank"

from terra.core.fact_transactions

group by 1

order by 2 desc),

tab4 as (select purchaser as "Address", count(distinct tx_id) as "NFT Purchases Count",

rank () over (order by "NFT Purchases Count" desc) as "NFT Purchases Count Rank"

from terra.core.fact_nft_sales

group by 1

order by 2 desc)

select tab3."Address" as "Address", "Active Days", "Active Days Rank", "NFT Purchases Count", "NFT Purchases Count Rank"

from tab3 full outer join tab4 on tab3."Address"=tab4."Address")