影响时户数的全部SQL语句

-- 预安排停电影响时户数总体情况 

SELECT
COUNT (DISTINCT recordid_fragment) AS shijianshu,
round(
SUM (zykjshs) / COUNT (DISTINCT recordid_fragment),
2
) pingjunshihushu
FROM
kkx_outage_circuit_d d
WHERE
to_char(
d.start_date_time,
'yyyy-mm'
) >= '2018-01'
AND to_char(
d.start_date_time,
'yyyy-mm'
) <= '2018-03'
AND d.area_feature IN ('1', '2', '3', '4')
AND 1 =1
AND d.outage_kind = 2 




--重点关注预安排停电影响时户数200及以上的停电事件 

SELECT
COUNT (1) AS REAL

FROM
(
SELECT
recordid_fragment,
SUM (mv_consumer_count) pingjunshihushu
FROM
kkx_outage_circuit_d d
WHERE
to_char(
d.start_date_time,
'yyyy-mm'
) >= '2018-01'
AND to_char(
d.start_date_time,
'yyyy-mm'
) <= '2018-03'
AND d.area_feature IN ('1', '2', '3', '4')
AND 1 =1
AND d.outage_kind = 2
GROUP BY
d.recordid_fragment
HAVING
SUM (mv_consumer_count) >= 100
) t1 





--责任原因分析2 -