问my sql中的可用股票sql查询

EN

  Select IN.sum(rang) as TotalStock,
    (IN.sum(rang) - OUT.sum(rang)) as AvStock ,
    IN.color as Color
    from stockIn IN , stockOut OUT
    where IN.color = OUT.color ;

 Select sum(si.rang) as TotalStock,sum(ifnull(so.ostock,0)) as OutStock,
  sum(si.rang-ifnull(so.ostock,0) ) as avgstock,si.color from stockin si 
 left join 
  (select sum(rang) as ostock,color from stockout group by color) so on si.color=so.color
  group by si.color

SELECT 
    sin.rang, 
    IFNULL(sum(sout.rang), 0) as sold, 
    sin.rang - IFNULL(sum(sout.rang), 0) AS av_stock, 
    sin.color 
FROM stock_in sin 
LEFT JOIN stock_out sout ON sout.color = sin.color
GROUP BY sin.color;