请教一个聚合查询的SQL，请高手指教

[haitr]

说明：
InOrOut，收入(1)/支出(0)
Account, 储蓄账户ID
Money，消费/收入金额
PYDate，记录时间


需求：

查询每个账户的最后消费日期，总共收入和支出金额

还望能得到高手的帮助啊。。 谢谢了

[百年树人]

select Account,max(PYDate) as 最后消费日期,
  sum(case when InOrOut=1 then [money] else 0 end) as 总共收入,
  sum(case when InOrOut=0 then [money] else 0 end) as 支出金额
from tb
group by Account

[开着拖拉机泡妞]

[Quote=引用 1 楼 的回复:]

SQL code
select Account,max(PYDate) as 最后消费日期,
sum(case when InOrOut=1 then [money] else 0 end) as 总共收入,
sum(case when InOrOut=0 then [money] else 0 end) as 支出金额
from tb
group by Account
[/Quote]

看不到图片，是树哥这意思么？