[{"_id":{"$oid":"65d881d4d080a591933b1be2"},"title":"Iphone 15","category":{"$oid":"65d881b1831df3b991251f56"},"brand":"Apple","properties":{"memory":["64GB","128GB","256GB"],"color":["black","white"]},"price":{"$numberLong":"1200"},"variants":[{"title":"Iphone 15 64GB black","SKU":"1123-1231-45lsaph15","price":{"$numberLong":"1200"},"properties":{"memory":"64GB","color":"black"},"stock":{"$numberLong":"24"}},{"title":"Iphone 15 128GB black","SKU":"1123-1231-75lsaph15","price":{"$numberLong":"1300"},"properties":{"memory":"128GB","color":"black"},"stock":{"$numberLong":"10"}},{"title":"Iphone 15 64GB white","SKU":"1123-1231-46lsaph15","price":{"$numberLong":"1200"},"properties":{"memory":"64GB","color":"white"},"stock":{"$numberLong":"20"}},{"title":"Iphone 15 128GB white","SKU":"1123-1231-76lsaph15","price":{"$numberLong":"1350"},"properties":{"memory":"128GB","color":"white"},"stock":{"$numberLong":"17"}}]}]

db.collection.aggregate([{$match:{"variants.SKU":"1123-1231-45lsaph15"}},{$set:{source:{$filter:{input:"$variants",as:"v",cond:{$eq:["$$v.SKU","1123-1231-45lsaph15"]}}}}},{$unwind:"$source"},{$project:{sameMemory:{$filter:{input:"$variants",as:"v",cond:{$eq:["$$v.properties.memory","$source.properties.memory"]}}},differentColor:{$filter:{input:"$variants",as:"v",cond:{$ne:["$$v.properties.color","$source.properties.color"]}}},sameMemoryButDifferentColor:{$filter:{input:"$variants",as:"v",cond:{$and:[{$eq:["$$v.properties.memory","$source.properties.memory"]},{$ne:["$$v.properties.color","$source.properties.color"]}]}}},source:1,_id:0}}])