17,377
社区成员
发帖
与我相关
我的任务
分享
select xingqi 星期, tianqi 天气, days 总数 from(
select xingqi,tianqi,sort1,sort2, count(id) days from
(select a1_1.zdz xingqi, a1_2.zdz tianqi, a1_1.sort sort1, a1_2.sort sort2
from A1 a1_1, A1 a1_2 where a1_1.zdmc='xq' and a1_2.zdmc = 'tq') a1_join
left join a2 on a1_join.xingqi=a2.xq and a1_join.tianqi=a2.tq
group by xingqi,tianqi, sort1, sort2
) order by sort1, sort2;