通信基站和通信技术机房

SELECT  nowtime.EC_CITY_NAME as EC_CITY_NAME,
        nowtime.EC_ITEM_TIME as EC_ITEM_TIME,
        nowtime.EC_ARENA_NAME as EC_ARENA_NAME,
        nowtime.TOTAL_USAGE as NOW_TOTAL_USAGE,
        lastmonth.TOTAL_USAGE as YEAR_TOTAL_USAGE,
       
        CASE
        WHEN nowtime.TOTAL_USAGE is null  THEN 0
        WHEN  nowtime.TOTAL_USAGE = 0 THEN 0
        ELSE
            CASE WHEN lastmonth.TOTAL_USAGE is null  THEN 0
            WHEN lastmonth.TOTAL_USAGE = 0 THEN 0
            ELSE round(nowtime.TOTAL_USAGE/lastmonth.TOTAL_USAGE,4)
            END
        END as TOTALUSAGECOMPARELASTMONTH,
        
        
        nowtime.AIRCON_USAGE as NOW_AIRCON_USAGE,
         lastmonth.AIRCON_USAGE as YEAR_AIRCON_USAGE,
         CASE
        WHEN nowtime.AIRCON_USAGE is null  THEN 0
        WHEN  nowtime.AIRCON_USAGE = 0 THEN 0
        ELSE
            CASE WHEN lastmonth.AIRCON_USAGE is null  THEN 0
            WHEN lastmonth.AIRCON_USAGE = 0 THEN 0
            ELSE round(nowtime.AIRCON_USAGE/lastmonth.AIRCON_USAGE,4)
            END
        END as AIRCONUSAGECOMPARELASTMONTH,
         
        nowtime.MAIN_USAGE as NOW_MAIN_USAGE,