SELECT AUDITOR_ID, SUM(REPORT_WEIGHT) AS CURRENT_TOTAL_WORKLOAD, count(REPORT_WEIGHT) AS COUNT_REPORT_WEIGHTS, count(*) AS COUNT_REPORTS FROM AP_AUD_QUEUES GROUP BY AUDITOR_ID
View Text - HTML Formatted
SELECT AUDITOR_ID , SUM(REPORT_WEIGHT) AS CURRENT_TOTAL_WORKLOAD , COUNT(REPORT_WEIGHT) AS COUNT_REPORT_WEIGHTS , COUNT(*) AS COUNT_REPORTS FROM AP_AUD_QUEUES GROUP BY AUDITOR_ID