select*from card where isLock=0 order by openDate; select userId,count(userId) from card group by userId; select*from card ORDER BY money DESC limit 3; select*from card order by openDate<'2019-04-00' desc limit 1; SELECT userId,sum(money) from card group by userId ORDER BY sum(money);