sql server 动态统计问题，求大神

[edcwsx_123]

日期 现场沟通已预约 电话沟通已预约 微信沟通已预约 现场沟通无意向 电话沟通无意向 微信沟通无意向
2018-09 1 0 1 0 2 0

表 a
日期
沟通方式
客户意向

表 b字典
沟通方式
客户意向

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(
	d CHAR(7),
	title NVARCHAR(10),
	remark NVARCHAR(10)
)
GO
INSERT INTO t VALUES ('2018-09','现场沟通','已预约')
INSERT INTO t VALUES ('2018-09','电话沟通','无意向')
INSERT INTO t VALUES ('2018-09','微信沟通','已预约')
INSERT INTO t VALUES ('2018-09','电话沟通','无意向')

SELECT  
SUM(CASE WHEN title='现场沟通' AND remark='已预约' THEN 1 ELSE 0 END) AS [现场沟通已预约]
,SUM(CASE WHEN title='电话沟通' AND remark='已预约' THEN 1 ELSE 0 END) AS [电话沟通已预约]
,SUM(CASE WHEN title='微信沟通' AND remark='已预约' THEN 1 ELSE 0 END) AS [微信沟通已预约]
,SUM(CASE WHEN title='现场沟通' AND remark='无意向' THEN 1 ELSE 0 END) AS [现场沟通无意向]
,SUM(CASE WHEN title='电话沟通' AND remark='无意向' THEN 1 ELSE 0 END) AS [电话沟通无意向]
,SUM(CASE WHEN title='微信沟通' AND remark='无意向' THEN 1 ELSE 0 END) AS [微信沟通无意向]
FROM t
GROUP BY t.d