select*from card where isLock=0 order by openDate asc select userId ,count(userId) from card group by userId select*from card select *from card where money order by money desc limit 0,3 select*from card where openDate between '0000-00-00'and '2019-03-31' ORDER BY money LIMIT 0,1 select userId,sum(money) from card GROUP BY userId ORDER BY sum(money)