下面两个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.terminalNOLEFT JOIN tb_res_city c ON c.tran_id=t.cityCodeWHERE 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;
下面两个sql怎么整合到一起

SELECT t.name,COUNT(DISTINCT t.terminalNO) as num FROM(SELECT DISTINCT c.name,c.code,t.terminalNOFROM device2.tb_terminal_list t LEFT JOIN tb_orbit_list o ON t.terminalNO=o.terminalNOLEFT JOIN tb_res_city c ON c.tran_id=t.cityCodeWHERE 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.terminalNOHAVING DATEDIFF(NOW(),MAX(o.opeTme))>90)tGROUP BY t.code;
下面两个sql怎么整合到一起
这两个sql的结果怎么整合到一起结果为下图
下面两个sql怎么整合到一起