SELECT X.DAY_TYPE_CD AS STAT_TP,                            
       Y.ATRD_NM, Y.DRCT_CD_NM, Y.DRCT_NM,                  
       X.*                                                  
  FROM (SELECT /*+ INDEX(A PK_TAS_IFSC_SPED_HH) */          
               A.DAY_TYPE_CD, B.ATRD_ID,                    
               ROUND(AVG(H00), 0) AS H00,                   
               ROUND(AVG(H01), 0) AS H01,                   
               ROUND(AVG(H02), 0) AS H02,                   
               ROUND(AVG(H03), 0) AS H03,                   
               ROUND(AVG(H04), 0) AS H04,                   
               ROUND(AVG(H05), 0) AS H05,                   
               ROUND(AVG(H06), 0) AS H06,                   
               ROUND(AVG(H07), 0) AS H07,                   
               ROUND(AVG(H08), 0) AS H08,                   
               ROUND(AVG(H09), 0) AS H09,                   
               ROUND(AVG(H10), 0) AS H10,                   
               ROUND(AVG(H11), 0) AS H11,                   
               ROUND(AVG(H12), 0) AS H12,                   
               ROUND(AVG(H13), 0) AS H13,                   
               ROUND(AVG(H14), 0) AS H14,                   
               ROUND(AVG(H15), 0) AS H15,                   
               ROUND(AVG(H16), 0) AS H16,                   
               ROUND(AVG(H17), 0) AS H17,                   
               ROUND(AVG(H18), 0) AS H18,                   
               ROUND(AVG(H19), 0) AS H19,                   
               ROUND(AVG(H20), 0) AS H20,                   
               ROUND(AVG(H21), 0) AS H21,                   
               ROUND(AVG(H22), 0) AS H22,                   
               ROUND(AVG(H23), 0) AS H23,                   
               ROUND(AVG(SPD), 0) AS SPD                    
          FROM TB_TAS_IFSC_SPED_HH A,                       
               MV_ATRD_IFSC        B                        
         WHERE A.STAT_DAY BETWEEN '20190601' AND '20190701'         
           AND A.IFSC_ID = B.IFSC_ID                        
         GROUP BY A.DAY_TYPE_CD, B.ATRD_ID, B.DRCT_CD       
       ) X,                                                 
       MV_ATRD Y                                            
 WHERE 1=1                                                  
   AND Y.ATRD_ID = X.ATRD_ID                                
 ORDER BY X.DAY_TYPE_CD, Y.ATRD_NM