第一段代码

# 各前置仓单品周转

use item;
select temp.SP码,temp.spname,temp.仓库,temp.城市,temp.前置仓库存量,temp.前30天销售,ifnull(if(前置仓库存量>0,前置仓库存量/(前30天销售/30),0),'有库存无销售') as 库存周转天数,if(ifnull(temp.成本,0)=0,'非249清单','249清单') as 分类
from (
select t1.SP码,t1.spname,t1.仓库,t1.城市,t1.wms库存量 as 前置仓库存量, sum(ifnull(t2.发货数量,0)) as 前30天销售,t3.SP码 sp,t3.成本
from stock t1
left join sales t2
on t1.SP码 = t2.sp码 and t1.仓库 = t2.仓库
left join 249_price t3
on t1.SP码 = t3.SP码
group by t1.SP码,t1.仓库
) temp