国产欧美精品专区一区二区_91www永久在线精品果冻传媒_日韩成人亚洲综合专区无码av_欧美激情一区二区三区高清视频_免费福利在线视频亚洲_日韩精品无码人妻自慰喷水_把腿张开老子cao哭你动态图_51a性爱高清免费视频_国产无码资源在线观看資源免費看_再深点灬舒服灬太大了网站

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

            ;