从另一列中插入不同值的SQL插入计数。

I'm currently struggling with the following query. I've a table in a database with a list of companies and a number of products they have. I'm looking to I'm currently struggling with the following que