queries for openclosed windows and all billing companies