SQL Server查询将花费的夜晚分成相应的“月”列

I'm using SQL Server 2012 and I need to write a query that will split the difference between the Date of Arrival and Date of Departure (that is, number of nights spent) and post the result into its respective I'm using SQL Server 2012 and I need to write a