是否有更好，更优化的方法来执行此SQL查询？

I have a SQL query where we are selecting a list of products but also need to query an orders table to find how many have been sold. Is there a more efficient way to retrieve the numberSold sum without a subQuery? I have a SQL query where we are selecting a lis