select

date_trunc('WEEK', BLOCK_TIMESTAMP) as WEEKLY,

ATTRIBUTE_VALUE as "Origin Chains",

sum(

case

when ATTRIBUTE_VALUE = 'Ethereum' then 10

when ATTRIBUTE_VALUE in (

'Moonbeam',

'Fantom',

'arbitrum',

'Polygon',

'celo',

'binance'

) then 1

when ATTRIBUTE_VALUE in (

'osmosis',

'Axelarnet',

'Avalanche',

'cosmoshub',

'assetmantle',

'juno',

'comdex',

'agoric',

'aurora',

'crescent',

'e-money',

'kujira',

'evmos',

'fetch',

'injective',

'terra',

'umee',

'ki',

'regen',

'secret',