Mysql创建视图语句

最新推荐文章于 2024-07-29 16:47:17 发布

A_010001001110

最新推荐文章于 2024-07-29 16:47:17 发布

阅读量2k

点赞数 1

分类专栏： python 文章标签： mysql

本文链接：https://blog.csdn.net/A_010001001110/article/details/103304041

版权

python 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

create view V_Cate_FourCate as 
	select 
		Cate2.品类,
		ReturnRate_SKU.月份,
		sum(ReturnRate_SKU.出库量) as '出库量',
		sum(ReturnRate_SKU.出库额) as '出库额',
		sum(ReturnRate_SKU.出库吊牌额) as '出库吊牌额',
		sum(ReturnRate_SKU.退货量) as '退货量',
		sum(ReturnRate_SKU.退货额) as '退货额',
		sum(ReturnRate_SKU.退货吊牌额) as '退货吊牌额',
		sum(ReturnRate_SKU.净销量) as '净销量',
		sum(ReturnRate_SKU.净销额) as '净销额',
		sum(ReturnRate_SKU.净销吊牌额) as '净销吊牌额',
		avg(ReturnRate_SKU.吊牌价) as '平均吊牌价',
		sum(ReturnRate_SKU.退货量)/sum(ReturnRate_SKU.出库量) as '退货率',
		sum(ReturnRate_SKU.退货额)/sum(ReturnRate_SKU.出库额) as '退款率',
		sum(ReturnRate_SKU.出库额)/sum(ReturnRate_SKU.出库量)/avg(ReturnRate_SKU.吊牌价) as '平均折扣率'
	from ReturnRate_SKU left join Cate2 
		on ReturnRate_SKU.codenumber = Cate2.中类编号 
	where 
		年份 = 2019 and 
		款号 REGEXP '^1[9Dd]' 
	group by 
		Cate2.品类,ReturnRate_SKU.月份;
	```