How many assets can each parts be used in? List the part name and the number.
select t1.part_name, count(*) from parts as t1 join asset_parts as t2 on t1.part_id = t2.part_id group by t1.part_name