suite_test_case_count

Column	Type
id	BLOB
name	BLOB
created_by	BLOB
created_at	BLOB
sum(tc.test_case_count)

SQL DDL

CREATE VIEW suite_test_case_count AS 
SELECT 
st.id,
st.name,
st.created_by,
st.created_at,
sum(tc.test_case_count)
FROM
test_cases_run_status tc
INNER JOIN test_suites st on st.id=tc.suite_id