SQL Query vs Asp.net gridview

Question

i am having below MS Access Table now i need to sum the price for every customer

 

have to display into gridview

below format

customer	price
person	sum(price)
person	sum(price)

 kindly help me out Thanks in advance