select tbl_lab_setup_Test.Test_Code ,tbl_lab_setup_Test.Test_Name ,count(tbl_lab_setup_Test.Test_Name) as Count from [tbl_lab_log_Staff_Action] join view_lab_information_Request on [tbl_lab_log_Staff_Action].LSA_LN = view_lab_information_Request.IREQ_LN join tbl_lab_setup_Test on [tbl_lab_log_Staff_Action].[LSA_TEST_CODE] = tbl_lab_setup_Test.Test_Code where [LSA_TYPE] = 'ResRerun'