下面一段代码
哪里错了呢
找找看
SELECT *
FROM (SELECT City_name
,SUM(W_new_user_cnt) AS W_new_user_cnt
,Ds
FROM Pub_cockpit_db.Ads_mob_dri_user_gather_ws
WHERE Ds BETWEEN ‘20201001’ AND ‘20201010’
AND City_name in (‘南京市’,‘杭州市’,‘武汉市’,‘长沙市’ ,‘广州市’,‘天津市’,‘重庆市’,‘长春市’,‘成都市’,‘郑州市’,‘福州市’)
GROUP BY City_name
,Week
,Ds
) b1
UNION ALL
(SELECT ‘全国’ AS City_name
,SUM(W_new_user_cnt) AS W_new_user_cnt
,Ds
FROM Pub_cockpit_db.Ads_mob_dri_user_gather_ws
WHERE Ds BETWEEN ‘20201001’ AND ‘20201010’
AND City_name in (‘南京市’,‘杭州市’,‘武汉市’,‘长沙市’ ,‘广州市’,‘天津市’,‘重庆市’,‘长春市’,‘成都市’,‘郑州市’,‘福州市’)
GROUP BY City_name
,Week
,Ds
) b2