unit_type,

count(distinct unit_id) as total_units,

count(distinct owner_address) as unique_creators,

avg(array_size(subcomponent_ids)) as avg_subcomponents,

min(block_timestamp) as first_registration,

max(block_timestamp) as last_registration

from crosschain.olas.ez_unit_registrations

group by 1

order by total_units desc;