select C_ID from (select top 100 percent c_ID,CompanyName,(select count(*) from Product where C_ID=companyInfo.C_ID) SC from companyInfo
where C_ID not in(select min(C_ID) from companyInfo group by companyname ) order by len(C_ID) asc) t where SC<1
