[{"HomeTeam":"Chelsea","HTScore":2,"FTR":"D","AwayTeam":"Everton","ATScore":2},{"HomeTeam":"Chelsea","HTScore":3,"FTR":"H","AwayTeam":"Wolves","ATScore":1},{"HomeTeam":"Chelsea","HTScore":2,"FTR":"D","AwayTeam":"Everton","ATScore":2},{"HomeTeam":"Liverpool","HTScore":1,"FTR":"A","AwayTeam":"Aston Villa","ATScore":3},{"HomeTeam":"Liverpool","HTScore":6,"FTR":"H","AwayTeam":"Chelsea","ATScore":3}]

db.collection.aggregate([{"$group":{"_id":"$HomeTeam","result":{"$push":"$FTR"},"goals":{"$push":"$HTScore"}}},{"$set":{"draws":{"$filter":{"input":"$result","as":"d","cond":{"$eq":["$$d","D"]}}},"wins":{"$filter":{"input":"$result","as":"w","cond":{"$eq":["$$w","H"]}}},"defeat":{"$filter":{"input":"$result","as":"d","cond":{"$eq":["$$d","A"]}}}}},{"$project":{"HomeTeam":"$_id","Number_of_victories":{"$size":"$wins"},"Number_of_draws":{"$size":"$draws"},"Number_of_defeats":{"$size":"$defeat"},"Max_goals":{"$max":"$goals"}}}])