我有两张桌子:
Companies: (id, name, city)
Workers: (id, name)
我想得到所有的公司,并按员工人数进行分类.
结果应该是:
count | company id | company name | city
------------------------------------------
90 6 foo corp NY
45 9 bar corp LA
0 3 foobar corp HO
我试过:
select
c.*,
count(w.id) as c
from
companies c
left join
workers w
on
c.id = w.company_id
group by
c.id
order by
c desc;
但这不起作用,因为它告诉我也要按g.名称分组:/
有什么 idea 吗?