How many assets does each third party company supply? List the count and the company id.
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
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
[{'count(*)': 1, 'company_id': 1}, {'count(*)': 3, 'company_id': 2}, {'count(*)': 2, 'company_id': 5}, {'count(*)': 3, 'company_id': 6}, {'count(*)': 1, 'company_id': 7}, {'count(*)': 1, 'company_id': 8}, {'count(*)': 1, 'company_id': 11}, {'count(*)': 1, 'company_id': 12}, {'count(*)': 1, 'company_id': 13}, {'count(*)': 1, 'company_id': 14}]