Show me assets supplied by each third party company.
select * from third_party_companies as t1 join assets as t2 on t1.company_id = t2.supplier_company_id group by t1.company_id
How many are there for each third party company? Show me the company id as well.
select count(*), t1.company_id from third_party_companies as t1 join assets as t2 on t1.company_id = t2.supplier_company_id group by t1.company_id