case

when NAME ilike '%valory%' then 'valory'

when NAME ilike '%eightballer%' then 'eightballer'

when NAME ilike '%elcollectooorr%' then 'elcollectooorr'

when NAME ilike '%dvilela%' then 'dvilela'

when NAME ilike '%zarathustra%' then 'zarathustra'

when NAME ilike '%balancer%' then 'balancer'

when NAME ilike '%jhehemann%' then 'jhehemann'

when NAME ilike '%algovera%' then 'algovera'

when NAME ilike '%postmint%' then 'postmint'

when NAME ilike '%fetchai%' then 'fetchai'

else 'others'

end as authorship,

count(distinct TX_HASH) as no_components

from crosschain.olas.ez_unit_registrations

where UNIT_TYPE = 'component'

group by 1