Archives

Custom SQL query returning 2 rows (hide)

SELECT DATE(timestamp) AS date, SUM(CASE WHEN online = 0 THEN 1 ELSE 0 END) AS offline_count, SUM(CASE WHEN online = 1 THEN 1 ELSE 0 END) AS online_count FROM online_status GROUP BY DATE(timestamp) ORDER BY date;