select type,sum(money) from transinfo GROUP BY type
select *from transinfo order by money desc limit 1;
select cardno,sum(money) from transinfo group by cardno
select cardno,avg(money) from transinfo group by cardno order by avg(money)
select cardno,avg(money) from transinfo group by cardno
having avg(money)>1000 order by avg(money)
select type from transinfo order by money desc limit 0,3;