MySQL 은 사용해본적이 없어서 -_-;;;

MSSQL 쿼리로 작성되었습니다.

mysql 에 맞게 수정하셔서 쓰시면 될듯요.

참고만 하세요..

---쿼리시작---

with tblA (DEVICE_ADDRESS,DATA_DT,TEMPERATURE) As
(
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:00:56',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:01:56',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:02:56',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:03:56',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:04:56',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:05:56',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:06:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:07:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:08:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:09:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:10:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:11:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:12:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:13:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:14:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:15:57',23.7     Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:16:57',23       Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:17:57',23       Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:18:57',23       Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:19:57',23       Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:50:57',23       Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 18:50:57',23       Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-07 18:50:57',23       Union All
       Select 'DF:7F:78:CB:45:C2','2015-11-02 15:20:57',23.1
)
               Select a.DEVICE_ADDRESS    As DEVICE_ADDRESS
                     ,a.DT + ' ' + Min(DT_TIME)   As DATA_DT
                     ,  Sum(a.TEMPERATURE)
                      / Count (a.TEMPERATURE)   As TEMPERATURE
                 From
                     (
                         Select a.DEVICE_ADDRESS    As DEVICE_ADDRESS
                               ,a.DT                As DT
                               ,Left(Convert(varchar(max),a.DT_MIN / 5),1)    As MIN_SEQ
                               ,a.DT_MIN
                               ,a.DT_HOUR           As DT_HOUR
                               ,a.DT_TIME           As DT_TIME
                               ,a.TEMPERATURE       As TEMPERATURE
                           From (
                                      Select a.DEVICE_ADDRESS            As DEVICE_ADDRESS
                                            ,SubString(a.DATA_DT,1,10)   As DT
                                            ,SubString(a.DATA_DT,12,2)   AS DT_HOUR
                                            ,Convert(Decimal(18,0),SubString(a.DATA_DT,15,2),0)  As DT_MIN
                                            ,SubString(a.DATA_DT,12,8)   AS DT_TIME
                                            ,a.TEMPERATURE               As TEMPERATURE
                                        From tblA a
                                ) a
                     ) a
             Group By a.DEVICE_ADDRESS
                     ,a.DT
                     ,a.DT_HOUR + a.MIN_SEQ
                     --,a.MIN_SEQ
---쿼리끝----                    

---결과---

DF:7F:78:CB:45:C2 2015-11-02 15:00:56 23.700000
DF:7F:78:CB:45:C2 2015-11-02 15:05:56 23.583333
DF:7F:78:CB:45:C2 2015-11-02 15:10:57 23.700000
DF:7F:78:CB:45:C2 2015-11-02 15:15:57 23.140000
DF:7F:78:CB:45:C2 2015-11-02 15:20:57 23.100000
DF:7F:78:CB:45:C2 2015-11-02 18:50:57 23.000000
DF:7F:78:CB:45:C2 2015-11-07 18:50:57 23.000000

SELECT device_address
     , MIN(data_dt) data_dt
     , AVG(temperature) temperature
  FROM tblA
 GROUP BY device_address
     , DATE_FORMAT(data_dt, '%Y-%m-%d %H')
     , FLOOR(DATE_FORMAT(data_dt, '%i') / 5)
;