SELECT
COUNT(id) AS totalCount,
SUM(CASE WHEN last_active_time>'2017-07-21 15:41:21' THEN 1 ELSE 0 END) AS onlineCount,
SUM(CASE WHEN last_active_time>'2016-07-21 15:41:21' THEN 1 ELSE 0 END) AS offline7Count,
SUM(CASE WHEN last_active_time>'2015-07-21 15:41:21' THEN 1 ELSE 0 END) AS offline90Count
FROM android_identification ;