sql grouping and sum claims totals : i am new in sql, I am trying to group the following 
CLAIM #	    LINE SEQ	AMNT BILLED	AMOUNT ALLOWED 	AMOUNT PAID	COPAY
LA123456	1	20	18	15	3
LA123456	2	10	5	5	0
LA123456	3	50	30	30	0
MS123456	1	20	18	15	3
MS123456	2	10	5	5	0
MS123456	3	50	30	30	0
 I am expecting to see something like this
CLAIM #		AMOUNT BILLED	AMOUNT ALLOWED 	AMOUNT PAID	COPAY
LA123456		80	53	50	3
MS123456		80	53	50	3
Any advise on how to do it?