updated lease analytics query