Sum of each user data in SQL SERVER

Question

Name	Price	Discount
A	10	2
A	20	5
A	55	3
Total	85	11
B	5	6
B	15	9
B	10	2
Total	30	17

 

 

 

The above table has separate total for each user. How to calculate it in sql server and return and different dataset or a combine dataset