SELECT company_id,company_name ,count(hazard_type =1 or null ) cun1 ,count(hazard_type =2 or null ) as cun2,count(hazard_type =3 or null) as cun3
FROM `hazard_unit`
GROUP BY company_id,company_name
1,count ,count(hazard_type =1 or null )SELECT company_id,company_name ,count(hazard_type =1 or null ) cun1 ,count(hazard_type =2 or null ) as cun2,count(hazard_type =3 or null) as cun3FROM `hazard_unit` GROUP BY company_id,company_name