In there current query they don't use a a date range rather they go by the year that is hard coded in the query this is one of the columns in tbloan, then the expected_close is also a column in tbloan also which is hard coded in the current query. the expected_close is 1-12 for each month. That's how they are determining the counts for each month by inputting for example 9 for the month of Sept.

Better 🙂

Thanks