SELECT s.department_id, s.statement_id,
    COUNT(s.stmt_close_date)
    AS sd, t.trans_id, s.status, c.type,
    from_unixtime(s.stmt_close_date)
    FROM statement s
    INNER JOIN trans t
    ON t.statement_id=s.statement_id
    INNER JOIN cde c
    ON t.cde=c.cde
    INNER JOIN department d
    ON s.department_id=d.department_id
    INNER JOIN verify v
    ON v.department_id=d.department_id
    WHERE from_unixtime(s.stmt_close_date) BETWEEN
    DATE_SUB(from_unixtime(d.exp_date), INTERVAL 1 MONTH) AND
    from_unixtime(d.exp_date)
    AND d.period=‘1’
    AND s.status='closed'
    AND t.dollars>0
    AND c.type='periodic'
    AND v.status='active'
    AND d.status='active'
    GROUP BY s.statement_id DESC
    HAVING sd>1