Then you can ask the questions, during what times is at least one room of a type occupied or when are all rooms of a particular type unoccupied.New features in SQL 2012 have been developed to make short work of some of these gaps problems, so we will nee...