The query below will get you the number of tests with a status of Passed, Failed, Not Completed, Blocked, or N/A with the most recent execution date, that were executed each month from January to December for 2016. You may need to tweak it some to fit your needs.

SELECT YEAR(TC_EXEC_DATE) [Year], MONTH(TC_EXEC_DATE) [Month],
DATENAME(MONTH, TC_EXEC_DATE) As 'Month Name', COUNT(TC_STATUS) As 'Test Count'
FROM TESTCYCL
WHERE TC_EXEC_DATE LIKE '%2016%'
AND TC_STATUS IN ('Passed', 'Failed', 'Not Completed', 'Blocked', 'N/A')
GROUP BY YEAR(TC_EXEC_DATE), MONTH(TC_EXEC_DATE),
DATENAME(MONTH, TC_EXEC_DATE)
ORDER BY 1,2