Select count(cc.language) as language, c.name
from   Country c
Inner Join
CountryLanguage cc
on
c.Code = cc.CountryCode
where cc.language > 10
group by cc.language;

quote:

---

Originally posted by jgonzalez14

Can someone tell me what i am doing wrong here?

Select count(cc.language) as language, c.name
from   Country c
Inner Join
CountryLanguage cc
on c.Code = cc.CountryCode
group by c.name
having count(cc.language)>10
;

It seems the 'where' statement is making it error. W/o the where statement it works; however, when I put the where in it does not.

Thanks

---