Querying subdocuments to find all that have a greater quantity than 0

I have the following schema for an e-commerce clothing shop:

// Define the schema for the data
const ProductSchema = new mongoose.Schema({
name: String,
description: String, //client description of their product
category: { type: String, enum: productCategories},//shirt, t shirt,
material: String, //jean, cotton, ect
colors:[
{
color: String, //dark wash/ medium wash
sizes:[{
size: String,
inseams:[{
image: String,
inseam: Number,
price: Number,
stock: Number,
}]
}]
}
],

});
`
And I want to return a cursor to all the items that fit a specific color and have a stock greater than 0, regardless of size and inseam.

I’m struggling a lot to build a query, it seems I need to use some form of aggregation but I’m really at a loss here-- I just started using mongodb

Please read Formatting code and log snippets in posts and update your post so that we can easily read what you have posted.