#基础

full outer join

-- 过滤
SELECT  user_id
        ,COUNT(1) AS order_cnt
FROM    my_order
WHERE   ds = '${bizdate}'
GROUP BY user_id
HAVING  order_cnt > 10
LIMIT   100
;

-- 数据上卷
SELECT  ds_date
        ,CASE   WHEN GROUPING(status) = 1 THEN '合计'
                ELSE status
        END AS status
        ,COUNT(*) AS cnt
FROM    my_table
GROUP BY 
GROUPING SETS ((ds_date)
              ,(ds_date,status))
;