110,536
社区成员
发帖
与我相关
我的任务
分享
select a.memberId,b.memberName ,a.使用次数
from
(
select memberId,count(memberId) as '使用次数',max(cashTime) as time1
from CashLog
group by memberId
)as a left join Member b
on a.memberId= b.memberId
ordery by a.time1 desc