下面两个sql怎么整合到一起
SELECT c.name
AS city, COUNT(DISTINCT t.terminalNO
) AS cnt
FROM device2
.tb_terminal_list
t LEFT JOIN tb_orbit_list
o ON t.terminalNO
=o.terminalNO
LEFT JOIN tb_res_city
c ON c.tran_id
=t.cityCode
WHERE t.status
IN (‘在库’,‘领用’) AND t.godownCode
not in (‘13K53S’, ‘13K63S’, ‘13K43S’) AND t.devName
= ‘智能网关’ AND t.renovate
=1 AND o.opeMode
=‘翻新出库’ AND o.status
=‘在库’ GROUP BY c.nameORDER BY c.code;
SELECT t.name
,COUNT(DISTINCT t.terminalNO
) as num FROM(SELECT DISTINCT c.name,c.code
,t.terminalNO
FROM device2
.tb_terminal_list
t LEFT JOIN tb_orbit_list
o ON t.terminalNO
=o.terminalNO
LEFT JOIN tb_res_city
c ON c.tran_id
=t.cityCode
WHERE t.status
IN (‘在库’,‘领用’) AND t.godownCode
not in (‘13K53S’, ‘13K63S’, ‘13K43S’) AND t.devName
= ‘智能网关’ AND t.renovate
=1 AND o.opeMode
=‘翻新出库’ AND o.status
=‘在库’ GROUP BY t.terminalNO
HAVING DATEDIFF(NOW(),MAX(o.opeTme
))>90)tGROUP BY t.code
;
这两个sql的结果怎么整合到一起结果为下图