[Solved] I need the way to aggregate based on column value using MySQL

by


Here is a way to aggregate based on column value.

This query will give you count of on time and late student for a particular date.

SELECT 
    `Date`,
    DATE_FORMAT(`Date`, '%d') AS Month_Date,  -- You can modify it as per your requirement
    SUM(IF(`Attendance` = 'OnTime', 1, 0)) AS OnTime_Count,
    SUM(IF(`Attendance` = 'Late', 1, 0)) AS Late_Count
FROM attendance
WHERE `Date` >= CURRENT_DATE - INTERVAL 7 DAY
GROUP BY `Date`;

4

solved I need the way to aggregate based on column value using MySQL