count(distinct block_timestamp::date) as dt_cnt

from osmosis.core.fact_transactions

group by 1, 2 having dt_cnt >= 4)

select dayname(s.block_timestamp::date) as Days_of_the_Week,msg_type,

COUNT(DISTINCT active_users) as active_user_cnt,

COUNT(DISTINCT s.tx_id) as tx_cnt

from MINSOMOS q join osmosis.core.fact_transactions s on q.active_users = s.tx_from JOIN osmosis.core.fact_msgs w on w.tx_id = s.tx_id

and msg_type in ('tx','proposal_vote', 'delegate', 'ibc_transfer','lock_tokens','token_swapped', 'add_tokens_to_lock', 'pool_joined')

GROUP BY 1,2