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 SELECT * FROM transinfo WHERE transDate rlike '2019-07.' ORDER BY money DESC LIMIT 3