SELECT status, COUNT(*)
FROM table
WHERE day = ? AND month = ? AND year = ?
GROUP BY status