db={"Player":[{"_id":{"$oid":"6009cf73445ff54178c9f123"},"Nb_Player":10,"Name_Player":"Roddick","Nationality":"United States","Score":7,"Name_Tournament":"Roland Garros","Gender":"Male"},{"_id":{"$oid":"6009cf73445ff54178c9f124"},"Nb_Player":10,"Name_Player":"Roddick","Nationality":"United States","Score":8,"Name_Tournament":"Australia Open","Gender":"Male"},{"_id":{"$oid":"6009cf73445ff54178c9f125"},"Nb_Player":10,"Name_Player":"Roddick","Nationality":"United States","Score":8,"Name_Tournament":"Flusshing Meadows","Gender":"Male"},{"_id":{"$oid":"6009cf73445ff54178c9f126"},"Nb_Player":10,"Name_Player":"Roddick","Nationality":"United States","Score":0,"Name_Tournament":"Paris-Bercy Open","Gender":"Male"},{"_id":{"$oid":"6009cf73445ff54178c9f127"},"Nb_Player":20,"Name_Player":"Ginepri","Nationality":"United States","Score":8,"Name_Tournament":"Roland Garros","Gender":"Male"},{"_id":{"$oid":"6009cf73445ff54178c9f128"},"Nb_Player":30,"Name_Player":"Gasquet","Nationality":"France","Score":1,"Name_Tournament":"Australia Open","Gender":"Male"},{"_id":{"$oid":"6009cf73445ff54178c9f129"},"Nb_Player":40,"Name_Player":"Montfils","Nationality":"France","Score":3,"Name_Tournament":"Australia Open","Gender":"Male"},{"_id":{"$oid":"6009cf73445ff54178c9f12a"},"Nb_Player":100,"Name_Player":"Mauresmo","Nationality":"France","Score":null,"Name_Tournament":null,"Gender":"Female"},{"_id":{"$oid":"6009cf73445ff54178c9f12b"},"Nb_Player":200,"Name_Player":"Davenport","Nationality":"United States","Score":4,"Name_Tournament":"Roland Garros","Gender":"Female"}],"Teams":[{"_id":{"$oid":"6020251048a99f26045bb879"},"Nb_Team":1,"Name_Player_1":"Roddick","Name_Player_2":"Montfils","Score":9,"Name_Tournament":"Roland Garros"},{"_id":{"$oid":"6020251048a99f26045bb87a"},"Nb_Team":2,"Name_Player_1":"Ginepri","Name_Player_2":"Gasquet","Score":7,"Name_Tournament":"Roland Garros"},{"_id":{"$oid":"6020251048a99f26045bb87b"},"Nb_Team":1,"Name_Player_1":"Roddick","Name_Player_2":"Montfils","Score":7,"Name_Tournament":"Flusshing Meadows"},{"_id":{"$oid":"6020251048a99f26045bb87c"},"Nb_Team":2,"Name_Player_1":"Ginepri","Name_Player_2":"Gasquet","Score":8,"Name_Tournament":"Flusshing Meadows"}]}

db.Player.aggregate([{"$match":{"Nationality":"France","Score":{"$exists":true,"$ne":null}}},{"$lookup":{"from":"Teams","let":{name:"$Name_Player"},"pipeline":[{$match:{$expr:{$or:[{$eq:["$Name_Player_1","$$name"]},{$eq:["$Name_Player_2","$$name"]}]}}},{"$count":"cnt"}],"as":"Nb_Team"}},{"$unwind":"$Nb_Team"},{$project:{"_id":{"Player":"$Name_Player","Nationality":"$Nationality","Nb_Team":"$Nb_Team.cnt"}}}])