How to query this table?

Question

SQL

there is a task: product name, price, number of pieces sold in each order, add the field "amount of goods sold" except for goods under the Samsung brand (choose the brand arbitrarily,
I did: SELECT Name, Price,
FROM Products
question: how to deal with the number of pieces sold in each order, add the "amount of item sold" field except for Samsung-branded items?