SELECT * FROM (

select city_desc,tdmc,gasstation_desc, 

sum_gun_y,

sum_gun_m,

sum_gun_ytq,

NVL(sum_gun_y,0)-NVL(sum_gun_ytq,0) AS sum_gun_ytb,--'年同比'

NVL(sum_gun_ytb,0)/NVL(sum_gun_ytq,0) AS sum_gun_yzf,--'年增幅'

FROM 

  (select city_desc, tdmc,gasstation_desc,

  sum_gun1/DAYSOFYEAR('$tjdate') as sum_gun_y,

   sum_gun2/daysofmonth('$tjdate') as sum_gun_m,

   sum_gun3/DAYSOFYEAR('$tjdate1') as sum_gun_ytq,

FROM 

  ( SELECT city_desc,tdmc,gasstation_desc, 

   SUM(sum_gun) AS sum_gun1

   from app_nonoil.kl_labordata

   where year(('${tjdate}'||'-01')-1)=substr(post_date,1,4)

    group by city_desc,tdmc,gasstation_desc

  )

LEFT JOIN 

    ( SELECT city_desc,tdmc,gasstation_desc, 

   SUM(sum_gun) AS sum_gun2

   from app_nonoil.kl_labordata

   where year('${tjdate}'||'-30')=substr(post_date,1,4) and month('${tjdate}'||'-30')= substr(post_date,6,2)

    group by city_desc,tdmc,gasstation_desc

  )

LEFT JOIN 

   (select city_desc,tdmc,gasstation_desc, sum(sum_gun) as sum_gun3

from app_nonoil.kl_labordata

where year('${tjdate1}'||'-01')=substr(post_date,1,4)

 group by city_desc,tdmc,gasstation_desc

   )

  )

)