mysql> select ( count(*) / 288 ), max(date), max(usrpercent+nicepercent+syspercent+wiopercent), avg(usrpercent+nicepercent+syspercent+wiopercent), max(memused - memcache), avg(memused - memcache) from SERVER where epoch >= (select max(epoch)-3456000 from SERVER) and (time <= '09:00' or time >= '17:00'); +--------------------+-----------+---------------------------------------------------+---------------------------------------------------+-------------------------+-------------------------+ | ( count(*) / 288 ) | max(date) | max(usrpercent+nicepercent+syspercent+wiopercent) | avg(usrpercent+nicepercent+syspercent+wiopercent) | max(memused - memcache) | avg(memused - memcache) | +--------------------+-----------+---------------------------------------------------+---------------------------------------------------+-------------------------+-------------------------+ | 0.0000 | NULL | NULL | NULL | NULL | NULL | +--------------------+-----------+---------------------------------------------------+---------------------------------------------------+-------------------------+-------------------------+ 1 row in set (0.01 sec)