I need to group the result (SQL)

Job ID: 36398147

Budget: $10 – $30 USD

I have a SQL table where I list the sales of a company.
Product, quantity, amount, etc.
What I need is to be able to provide this information in a summarized way, by product.
But I don't just need the select, otherwise, update the table itself..
In the most efficient way possible, since the table is very large and takes a long time.