select statistics_date AS statisticsDate,
sum(ACTIVE_USER_END) AS activeUser,sum(ACTIVE_USER) from ACTIVE_USER_HOUR t1
WHERE t1.STATISTICS_SIGN =
(SELECT max(STATISTICS_SIGN) FROM ACTIVE_USER_HOUR t2 where LEFT( t1.STATISTICS_DATE,10) = LEFT(t2.STATISTICS_DATE,10)) GROUP BY STATISTICS_DATE
sum(ACTIVE_USER_END) AS activeUser,sum(ACTIVE_USER) from ACTIVE_USER_HOUR t1
WHERE t1.STATISTICS_SIGN =
(SELECT max(STATISTICS_SIGN) FROM ACTIVE_USER_HOUR t2 where LEFT( t1.STATISTICS_DATE,10) = LEFT(t2.STATISTICS_DATE,10)) GROUP BY STATISTICS_DATE