欧美成人精品手机在线观看_69视频国产_动漫精品第一页_日韩中文字幕网 - 日本欧美一区二区

SELECT

                SUM(CASE WHEN c.category_name = '女裙' THEN a.sales_volume ELSE 0 END) AS 女裙銷量

                ,SUM(CASE WHEN c.category_name = '兒童家具' THEN a.sales_volume ELSE 0 END) AS 兒童家具銷量

            FROM

                data_learning.product_order a

            LEFT JOIN

                (

                SELECT

                    *

                FROM

                    data_learning.product_category

                )c

                on a.category_id = c.category_id

              ;

SELECT

                SUM(IF(c.category_name = '女裙',sales_volume,0 )) AS 女裙銷量

                ,SUM(IF(c.category_name = '兒童家具',sales_volume,0)) AS 兒童家具銷量

            FROM

                data_learning.product_order a

            LEFT JOIN

                (

                SELECT

                    *

                FROM

                    data_learning.product_category

                )c

                on a.category_id = c.category_id

              ;

CREATE TABLE data_learning.tmp_test AS

            SELECT

                SUM(IF(c.category_name = '女裙',sales_volume,0 )) AS 女裙銷量

                ,SUM(IF(c.category_name = '兒童家具',sales_volume,0)) AS 兒童家具銷量

            FROM

                data_learning.product_order a

            LEFT JOIN

                (

                SELECT

                    *

                FROM

                    data_learning.product_category

                )c

                on a.category_id = c.category_id

            ;

SQL：

SELECT

                '女裙' AS 類別

                ,女裙銷量 AS 銷量

            FROM

                data_learning.tmp_test UNION ALL

SELECT

                '兒童家具' AS 類別

                ,兒童家具銷量 AS 銷量

            FROM

                data_learning.tmp_test

            ;