#携程笔试# 请问各位大佬数据方向最后一道SQLSELECT userid, cnt_1d, amt_1d, cnt_7d, amt_7d, cnt_15d, amt_15dFROM(SELECT userid, COUNT(*) as cnt_1d,SUM(amount) as amt_1d FROM edw_htl_order where orderdate between '2020-07-15' and '2020-07-16' group by userid)aJOIN(SELECT userid, COUNT(*) as cnt_7d,SUM(amount) as amt_7d FROM edw_htl_order where orderdate between '2020-07-09' and '2020-07-16' group by userid)bon a.userid = b.useridJOIN(SELECT userid, COUNT(*) as cnt_15d,SUM(amount) as amt_15d FROM edw_htl_order where orderdate between '2020-07-01' and '2020-07-16' group by userid)con a.userid = c.userid这个为啥过不了呀?每次合并SELECT查询都出问题