如何通过SQL语句在DB2中按天显示最近5天的审计记录，并在单行中显示它们的按天计数

SELECT 
    COUNT(CASE WHEN DATE(audit_date) = CURRENT DATE - 4 DAYS THEN 1 END) AS day_1_count,
    COUNT(CASE WHEN DATE(audit_date) = CURRENT DATE - 3 DAYS THEN 1 END) AS day_2_count,
    COUNT(CASE WHEN DATE(audit_date) = CURRENT DATE - 2 DAYS THEN 1 END) AS day_3_count,
    COUNT(CASE WHEN DATE(audit_date) = CURRENT DATE - 1 DAY THEN 1 END) AS day_4_count,
    COUNT(CASE WHEN DATE(audit_date) = CURRENT DATE THEN 1 END) AS day_5_count
FROM 
    audit_table
WHERE 
    audit_date >= CURRENT DATE - 4 DAYS;