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) a from transinfo GROUP BY cardNo Order by a;
select cardNo a from transinfo GROUP BY cardNo HAVING avg(money)>1000;
select * from transinfo where transDate like '2019-07%' order by money desc LIMIT 3