Unnamed

                 SELECT 
                    DISTINCT isu_usr_id,
                    usr_full_name,
                    SUM(CASE WHEN sta_is_closed=0 THEN 1 ELSE 0 END) AS total_open_items,
                    SUM(CASE WHEN sta_is_closed=1 THEN 1 ELSE 0 END) AS total_closed_items
                 FROM
                    eventum.eventum_issue,
                    eventum.eventum_issue_user,
                    eventum.eventum_user,
                    eventum.eventum_status
                 WHERE
                    isu_usr_id=usr_id AND
                    isu_iss_id=iss_id AND
                    iss_prj_id=1 AND
                    iss_sta_id=sta_id
                 GROUP BY
                    isu_usr_id
                 ORDER BY
                    total_open_items DESC