db={"lotteryticket":[{"_id":ObjectId("6021ce0cb4d2c2b4f24c3a2e"),"ticket":"T1","player":"Alice"},{"_id":ObjectId("6021ce0cb4d2c2b4f24c3a2f"),"ticket":"T2","player":"Bob"},{"_id":ObjectId("6021ce0cb4d2c2b4f24c3a33"),"ticket":"T3","player":"Charles"}],"lotterydrawing":[{"_id":ObjectId("63309480b749b733c087b758"),"ticket":"T3"},{"_id":ObjectId("63309480b749b733c087b759"),"ticket":"T9"},{"_id":ObjectId("63309480b749b733c087b75a"),"ticket":"T77"}]}

db.lotteryticket.aggregate([{$lookup:{from:"lotterydrawing",localField:"ticket",foreignField:"ticket",as:"drawnticket",}},{"$match":{$expr:{"$gt":[{$size:"$drawnticket"},0]}}}])