And how many companies are there with this type?
SELECT count ( DISTINCT name )  FROM operate_company WHERE Type  =  'Subsidiary'
number of companies = COUNT(DISTINCT name); with this type refers to WHERE Type = 'Subsidiary';