public IActionResult GetById() { var houses = _houseRepo.GetHouseStats(); var housesStats = _mapper.Map <List <HouseStats> >(houses); var targetList = new List <HouseStats>(); foreach (var house in houses) { var existing = targetList.FirstOrDefault(h => h.HouseType.ToLower() == house.Type.ToLower()); if (existing == null) { var count = houses.Where(h => h.Type == house.Type).Select(h => h.Likes.Count).Sum(); var stats = new HouseStats { NumberOfLikes = count, HouseType = house.Type }; targetList.Add(stats); } } return(Ok(targetList)); }