Select BrandDescription, CAPEXLookUp, count (*) frpm CAPEXRecord
inner join Facility on CAPEXRecord.facilityId= facility.facilityId
inner join FacilityBrand on facility.facilityBrand=facilityBrand.FacilityBrandId
inner join CAPEXLookUp on CapexLookUp.LookUpId= CAPEXRecord.lookupId
group by facilitybrand.branddescription, CAPEXLookUp.Description