SELECT

DISTINCT RECEIVER

FROM osmosis.core.fact_airdrop

WHERE currency LIKE 'uosmo'

), tab2 as (

SELECT

DISTINCT tx_id

FROM osmosis.core.fact_transactions

WHERE tx_from in (SELECT * from tab1 )

SELECT

date_trunc('week', block_timestamp),

msg_type,

COUNT(*)

FROM osmosis.core.fact_msgs

WHERE tx_id in (SELECT * from tab2)

GROUP BY 1,2