>order loan late1 late2 type > >11111 2222 1 0 CL >11111 3333 4 1 CL > >33333 4444 5 2 PL >33333 5555 6 3 PL > >44444 6666 8 4 ML >55555 7777 9 3 ML>
>select order,type,sum(late1) as late1x,sum(late2) as late2x from >mytable group by order,type;>
>order late1x late2x type > >11111 5 1 CL > >33333 11 5 PL > >44444 8 4 ML >55555 9 3 ML>