plz help me in finding the error in this query : tell me whether the query is correct or contains any error

select cname from company where id IN (select company_id,count(*) from medication group by(company_id) having count(*)>1) order by cname;