| 123456789101112131415161718192021 |
- SELECT
- A.期数,
- A.爱康,
- (A.爱康/(A.爱康+A.理想+A.QJ+A.其他)) AS 爱康比例,
- A.理想,
- (A.理想/(A.爱康+A.理想+A.QJ+A.其他))AS 理想比例,
- A.QJ,
- (A.QJ/(A.爱康+A.理想+A.QJ+A.其他))AS QJ比例,
- A.其他,
- (A.其他/(A.爱康+A.理想+A.QJ+A.其他))AS 其他比例,
- (A.爱康+A.理想+A.QJ+A.其他) AS 合计
- FROM
- (SELECT
- P.PERIOD_NUM AS 期数,
- (SELECT SUM(V1.`商品金额`) AS QJ FROM zr_product_pkg_vw V1 LEFT JOIN `产品信息` C1 ON V1.`存货编码` = C1.`存货编码` WHERE V1.`期数` = P.PERIOD_NUM AND C1.`来源` = 'QJ') AS QJ,
- (SELECT SUM(V4.`商品金额`) AS 爱康 FROM zr_product_pkg_vw V4 LEFT JOIN `产品信息` C4 ON V4.`存货编码` = C4.`存货编码` WHERE V4.`期数` = P.PERIOD_NUM AND C4.`来源` = '爱康') AS 爱康,
- (SELECT SUM(V5.`商品金额`) AS 理想 FROM zr_product_pkg_vw V5 LEFT JOIN `产品信息` C5 ON V5.`存货编码` = C5.`存货编码` WHERE V5.`期数` = P.PERIOD_NUM AND C5.`来源` = '理想') AS 理想,
- (SELECT SUM(V3.`商品金额`) AS 其他 FROM zr_product_pkg_vw V3 LEFT JOIN `产品信息` C3 ON V3.`存货编码` = C3.`存货编码` WHERE V3.`期数` = P.PERIOD_NUM AND C3.`来源` IS NULL) AS 其他
- FROM
- ar_period P
- WHERE P.PERIOD_NUM = 168) A
|
