合并两个按月计数的查询

灵感来自这个问题在Meta上 https://meta.stackexchange.com/questions/57692/have-the-new-bounty-changes-caused-more-bounties-to-appear，我在 Stack Exchange Data Explorer 上编写了两个查询，其中一个用于计算总数量按月提出的问题 https://data.stackexchange.com/stackoverflow/query/7667/questions-asked-by-month在 SO 和另一个计算按月授予的赏金 https://data.stackexchange.com/stackoverflow/query/7666/bounties-awarded-by-month。如何将它们组合起来以便在一个查询中获得输出？我倒要看看 一份报告中的年、月、问题、赏金和金额。

问题记录在 Posts 表中，其中 Post TypeId = 1，但赏金记录在 Votes 表中，其中 Vote TypeId = 9。

我在记事本中写了这个，并且还没有使用过数据浏览器。

select Isnull(V.Year, P.Year) As Year,
Isnull(V.Month, P.Month) As Month,
Isnull(V.Bounties, 0) As Bounties,
Isnull(V.Amount,0) As Amount ,
P.Questions
FROM
(
select
datepart(year, Posts.CreationDate) Year,
datepart(month, Posts.CreationDate) Month,
count(Posts.Id) Questions
from Posts
where PostTypeid = 1 -- 1 = Question
group by datepart(year, Posts.CreationDate), datepart(month, Posts.CreationDate)
) AS P
left JOIN
(
select
datepart(year, Votes.CreationDate) Year,
datepart(month, Votes.CreationDate) Month,
count(Votes.Id) Bounties,
sum(Votes.BountyAmount) Amount
from Votes
where VoteTypeId = 9 -- 9 = BountyAwarded
group by datepart(year, Votes.CreationDate), datepart(month, Votes.CreationDate)
) AS V
ON P.Year = V.Year AND P.Month = V.Month
order by P.Year, P.Month