Fixed aggregate query for vote counts hour for room number