Archives: Online status

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;

Edit SQL