mysql怎样合并结果集简化sql语句

Question

Answer 1

SELECT COUNT(DISTINCT Y) AS 一ノ瀬 FROM 17#01一ノ瀬 WHERE Y IS NOT NULL UNION ALL
SELECT COUNT(*) as hhh FROM 17#01一ノ瀬 WHERE A = '通常' AND DATE_FORMAT(Q,'%Y-%m')= '2017-01' AND K= 'T' UNION ALL
SELECT SUM(AA) FROM 17#01一ノ瀬 UNION ALL
SELECT SUM(AC) FROM 17#01一ノ瀬 UNION ALL
SELECT SUM(AE)FROM 17#01一ノ瀬 UNION ALL
SELECT COUNT(DISTINCT AF,AG) FROM 17#01一ノ瀬 WHERE AF IS NOT NULL AND AG IS NOT NULL UNION ALL
SELECT COUNT(*) FROM 17#01一ノ瀬 WHERE A = '通常' AND DATE_FORMAT(Q,'%Y-%m')= '2017-01' AND K= 'SE' OR K='SH' UNION ALL
SELECT SUM(AI+AO) FROM 17#01一ノ瀬 UNION ALL
SELECT SUM(AK+AQ) FROM 17#01一ノ瀬 UNION ALL
SELECT SUM(AM+AS) FROM 17#01一ノ瀬 ;

类似于这样的查询怎么简化啊 我感觉写了好多 我是个初学者 求大神 还有 要写6个类似于这样的查询 怎么将结果集合并