综合停电分析的全部SQL语句

-- 检修及施工停电户次  
SELECT
COUNT (DISTINCT d.app_no) AS realzonghushu
FROM
tm_f_zc_sc_kkx_outage_user_d d
WHERE
to_char(
d.start_date_time,
'yyyy-mm'
) >= '2018-01'
AND to_char(
d.start_date_time,
'yyyy-mm'
) <= '2018-02'
AND d.area_feature IN ('1', '2', '3', '4')
AND 1 =1
AND 1 =1
AND d.outage_kind = 2 




-- 检修及施工用户重复停电次数 
SELECT
num,
COUNT (1) countnum
FROM
(
SELECT

d.user_no,
COUNT (1) num
FROM
tm_f_zc_sc_kkx_outage_user_d d
WHERE
to_char(
d.start_date_time,
'yyyy-mm'
) >= '2018-01'
AND to_char(
d.start_date_time,
'yyyy-mm'
) <= '2018-02'
AND d.area_feature IN ('1', '2', '3', '4')
AND d.outage_kind = 2
GROUP BY
d.user_no
) T
GROUP BY
num
ORDER BY
num
  
  
  
 -- 责任原因分析 
  SELECT
t1.*, t2.f_code,
(
SELECT