Show me all assets each part can be used in. List the part name and the asset details.
select t1.part_name, t3.asset_details from parts as t1 join asset_parts as t2 on t1.part_id = t2.part_id join assets as t3 on t2.asset_id = t3.asset_id group by t1.part_name
How many assets can each part be used in? Show me the count and the part name.
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