从MySQL中的表中选择并添加两列相乘的结果

I'm trying to put together a MySQL query to select and multiply two columns from a specific table. In addition, I'd like the query to add the results of each multiplication if the value of a third column match any other rows.I'm trying to put together a MySQL query to sel