select  Alan1, sum(alan2) as alan1,sum(alan3) as alan3 from tabo group by Alan1
buna göre düzenleyip bir denermisin