SQL Server如何将3个查询合并为一个？

I want to condense the following three queries into one query and out put the totals into 3 columns. Oh and how do I make it so I don't have to declare the date. I want it to "know" the current date, month, and year. I want to condense the following three queries