created queries for house class and type population