sELECT `cardNo`,COUNT(type) from transinfo GROUP BY cardNo
SELECT * from ( SELECT `name`,COUNT(type),`transDate` from card c,user u,transinfo f where c.userId=u.userId and f.cardNo=c.cardNo GROUP BY name ORDER BY COUNT(type) DESC)c,card g LIMIT 1
SELECT money,c.cardNo,c.yue from ( SELECT cardNo ,sum(money)yue from transinfo f GROUP BY cardNo )c,card g WHERE c.cardNo=g.cardNo
SELECT money,c.cardNo,c.yue from ( SELECT cardNo ,sum(money)yue from transinfo f GROUP BY cardNo )c,card g WHERE c.cardNo=g.cardNo
SELECT name,fa from (sELECT `cardNo`,COUNT(type)fa from transinfo GROUP BY cardNo)c ,user f,card z where f.userId=z.userId and c.cardNo=z.cardNo SELECT name ,c.money from (sELECT `cardNo`,`money` from transinfo GROUP BY cardNo)c ,user f,card z where f.userId=z.userId and c.cardNo=z.cardNo ORDER BY money DESC SELECT SUM(c.money) FROM (SELECT transDate,money FROM transinfo WHERE transDate>'2019-06-30' and transDate<'2019-08-01')c SELECT city,SUM(c.money) FROM(SELECT money,type FROM transinfo WHERE type='支取' or type='转出')c,user v GROUP BY city ORDER BY SUM(c.money) DESC LIMIT 1 SELECT city,SUM(c.money) FROM(SELECT money,type FROM transinfo WHERE type='支取' or type='转出')c,user v GROUP BY city ORDER BY SUM(c.money) LIMIT 1