sql - Help me combine these two queries? -

Inspired by

, I asked two questions on stack exchange data explorer, which calculates the total number so that i How can I add them so that I have output in a query? I want to see the year, month, question, number, and amount in a report.

The questions are filed in the postal table, where posttap id = 1, but the ballots are filed in the table, where the voting id = 9

Select date format (year, rank, date of purchase) date, date format ( Months, Date (Date ID) Questions, Count (Vote.ID) Number, Zodiac (Voting Bounty amount) By date the amount joined the vote on the date format (year, post date date) = date format (year, Votes.Creation Debt) and DebtPart (Months, Post Causation Debt) = Datapter (Month, Voted Creditation Date), where Post Typed = 1 - 1 = Question and Vote: VotiveId ID = 9 - 9 = Date format according to date format Bounty Award Group (year, post, date, date, date) datepart (month, post.dressation date) date format (year, postage date, datedate) Sorted by postage date.) Does this work?

Kindly be kind. I have not worked with Data Explorer on Notepad and SA.

Edit:

  Elect to Isnull (V.Year, P.Year) years as, Isnull (V.Month, P (Month, Post), Month, select positions (Month, posts date) stamp (Month, post. Credits date), postpept = 1 - 1 = Date group by group of questions (year, post.) Credited years, vote. Countdown date (month, vote, date, date) month, counting (vote id) bounties, zodiac funds (vote amount outstanding) votes from vote where votetip ID = 9 - 9 = Bountyeded group by date group (year, VPYear = V. Year and P.Month = VPYear, P.Month  

as the main command) / div>