Ошибка в запросе? - MySQL

Формулировка задачи:

Всем привет! Вот запрос:
select maker, iif(count(pcs.pc)>=1,'yes('&count(pcs.pc)&')' ,'no')
 from Product left join (select count(*)as pc, model from pc  group by model ) pcs on Product.model=pcs.model
 left join (select count(*)as pc,model from laptop  group by model ) laptops on Product.model=laptops.model
 left join (select count(*)as pc,model from printer  group by model ) printers on Product.model=printers.model
group by maker
Так ругается: "Conversion failed when converting the varchar value 'yes(' to data type int." что ему не так и как изменить запрос?

Код к задаче: «Ошибка в запросе? - MySQL»

textual
select maker, 
(select case when count(pcs.pc)=0
    then 'no' else 'yes('+rtrim(convert(char(20),COUNT( pcs.pc))) +')' end) as pc,
(select case when count(laptops.pc)=0
    then 'no' else 'yes('+rtrim(convert(char(20),COUNT( laptops.pc))) +')' end) as laptop,
(select case when count(printers.pc)=0
    then 'no' else 'yes('+rtrim(convert(char(20),COUNT( printers.pc))) +')' end) as printer
 from Product left join (select count(*)as pc, model from pc  group by model ) pcs on Product.model=pcs.model
 left join (select count(*)as pc,model from laptop  group by model ) laptops on Product.model=laptops.model
 left join (select count(*)as pc,model from printer  group by model ) printers on Product.model=printers.model
group by maker

10   голосов, оценка 4.200 из 5


СОХРАНИТЬ ССЫЛКУ