question

Here are my two queries. and i wanna get three columns out of these two queries 1. modified_by_worker_full_name 2. '# Closed Incidents on First Contact' 3. 'Total Tickets closed'

I have done almost everything and used help from people but they couldnt figure this out.

SELECT modified_by_worker_full_name, COUNT(*)'# Closed Incidents on First Contact' FROM HD_workitem_detail_view WHERE workitem_status_lookup_id = '125' --PreClosed status post Dec 11, 2009 and modified_by_worker_name IN ('orichar', 'kprivot', 'cstewa2', 'cwilso4', 'bkey001', 'emachad', 'jsmith6', 'bmillig','eddie')

 AND workitem_number IN                     
              (                    
              SELECT workitem_number                    
              FROM HD_workitem_current_view                      
            WHERE  (workitem_version = 1                     
               or (workitem_version = 2 and workitem_modified_by_worker_id = 5))                    
               --and workitem_modified_by_worker_id = 5-- helpdesk user                    
                    AND workitem_modified_on BETWEEN '1/1/2010' AND '2/1/2010'                    
               )                    

GROUP BY modified_by_worker_full_name ORDER BY modified_by_worker_full_name

SELECT modified_by_worker_full_name, COUNT(*)'Total Tickets closed' FROM HD_workitem_detail_view
WHERE workitem_status_lookup_id = '125' --PreClosed status post Dec 11, 2009 AND modified_by_worker_name IN ('orichar', 'kprivot', 'cstewa2', 'cwilso4', 'bkey001', 'emachad', 'bmillig') AND (workitem_type_lookup_value Like 'incide%' or workitem_type_lookup_value LIKE 'Service%' ) AND workitem_number IN ( SELECT workitem_number FROM HD_workitem_current_view
WHERE workitem_status_lookup_id = '600' --Closed Status AND workitem_modified_by_worker_id = 5 -- helpdesk user AND workitem_modified_on BETWEEN '1/1/2010' AND '2/1/2010' )

GROUP BY modified_by_worker_full_name ORDER BY modified_by_worker_full_name