TSQL script writing from a Sql server tables

I want a script that will calculate
- how many nights guests stayed in total in our hotel from the arrival date and departure date.
- how much revenue was made from each guests (maybe using the total revenue column or a sum of roomrevenue, Foodrevenue and otherRevenue)
- guest lead time (which is the time they booked, until the time they checked in - that is arrival date minus reservation date)

this should be done for all definite stays only and IsActive and match stayID = profileStayID = CustomerMasterId from linkprofile table.

kindly contact me for the tables