一次sql排序的问题。
select date, count(fail) as fail,count(win) as win from
(select date,(case (result) when 'fail' then 'fail' end ) as fail,(case (result) when 'win' then 'win' end ) as win from games
) d group by date
select Name, Year , Month ,Count(Amount) as Income from
(select b.Name ,a.[Year] as Year ,a.[Month] as Month ,a.Amount as Amount from Test_Amount a left join Test_Users b on a.UserId=b.Id )
c group by Name,Year,Month
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步