select count(t1.job) as c_t1
,count(t2.job) as c_t2
,count(t3.job) as c_t3
,count(t4.job) as c_t4
from tb_name t1,tb_name t2,tb_name t3,tb_name t4
where t1.job = 'tis' and t1.accident='accident'
and t2.job = 'tis' and t2.accident='no accident'
and t3.job = 'mss' and t3.accident='accident'
and t4.job = 'mss' and t4.accident='no accident'
group by t1.job,t2.job,t3.job,t4.job