SELECT

case when msg_value:contract LIKE 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' THEN 'Anchor Market'

when msg_value:contract LIKE 'terra1tndcaqxkpc5ce9qee5ggqf430mr2z3pefe5wj6' THEN 'terra swap Luna-UST'

when msg_value:contract LIKE 'terra1gm5p3ner9x9xpwugn9sp6gvhd0lwrtkyrecdn3' THEN 'terra swap ANC-UST'

when msg_value:contract LIKE 'terra178jydtjvj4gw8earkgnqc80c3hrmqj4kw2welz' THEN 'Pylon MINE-UST'

when msg_value:contract LIKE 'terra17f7zu97865jmknk7p2glqvxzhduk78772ezac5' THEN 'Mirror Staking'

when msg_value:contract LIKE 'terra1amv303y8kzxuegvurh0gug2xe9wkgj65enq2ux' THEN 'terra swap MIR-UST'

when msg_value:contract LIKE 'terra1fxwelge6mf5l6z0rjpylzcfq9w9tw2q7tewaf5' THEN 'Spectrum spec staking'

when msg_value:contract LIKE 'terra1g7jjjkt5uvkjeyhp8ecdz4e4hvtn83sud3tmh2' THEN 'Apollo'

when msg_value:contract LIKE 'terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6' THEN 'Anchor Liquidation Contract'

when msg_value:contract LIKE 'terra1wfz7h3aqf4cjmjcvc6s8lxdhh7k30nkczyf0mj' THEN 'Mirror Mint'

when msg_value:contract LIKE 'terra1pdxyk2gkykaraynmrgjfq2uu7r9pf5v8x7k4xk' THEN 'Terraswap mTSLA-UST Pair'

when msg_value:contract LIKE 'terra14fyt2g3umeatsr4j4g2rs8ca0jceu3k0mcs7ry' THEN 'Terraswap mETH-UST Pair'

when msg_value:contract LIKE 'terra1sndgzq62wp23mv20ndr4sxg6k8xcsudsy87uph' THEN 'Terraswap LUNA-MNT Pair'

when msg_value:contract LIKE 'terra1zw0kfxrxgrs5l087mjm79hcmj3y8z6tljuhpmc' THEN 'Terraswap LUNA-KRT Pair'

when msg_value:contract LIKE 'terra19qx5xe6q9ll4w0890ux7lv2p4mf3csd4qvt3ex' THEN 'Terraswap Factory'

when msg_value:contract LIKE 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' THEN 'Anchor bLuna Hub'

ELSE 'not' END as t1

,

date_trunc('day', block_timestamp),

--sum(msg_value:coins[0]['amount'] / 100000)

COUNT(*)

FROM terra.msgs

WHERE msg_value:coins[0]['amount'] is not NULL

AND block_timestamp > CURRENT_DATE - 90

GROUP BY 1,2

SELECT * FROM tab1 WHERE not t1 LIKE 'not'