简单的SQL问题，在线等待解决 急！！

[lihan6415151528]

表people中
id name

1 aa
2 ee

表TechnologyStore中

peopleId

1
1
2
1
2
1
2
1
1
2
2
2
求出对应的 表people中name和表TechnologyStore中peopleId的个数

要求用一条语句实现

在线等待 急！！！

[天-笑]

select a.*,b.num from people a left join (select peopleId  ,count(peopleId) as num from TechnologyStore group by peopleId )  b
on a.id = b.peopleId  

[lgxyz]

SELECT A.ID,A.NAME,ACOUNT=COUNT(1) FROM PEOPLE A
LEFT JOIN TechnologyStore B
  ON A.ID=B.peopleId 
GROUP BY A.ID,A.NAME

[wgzaaa]

SELECT a.NAME,COUNT(peopleId) FROM people A LEFT JOIN TechnologyStore B ON A.ID=B.peopleId GROUP BY A.NAME

[viva369]

select aa.id,aa.name,count(*)  from people as aa
inner join TechnologyStore as bb on aa.id = bb.peopleid
group by aa.id，aa.name

[fangsp]

先顶一个

[fangsp]

select aa.id,aa.name,count(*)  from people as aa
inner join TechnologyStore as bb on aa.id = bb.peopleid
group by aa.id，aa.name

[wxg22526451]

select a.id,a.name,tcount=count(1) from people a left join TechnologyStore b on a.id=b.peopleid group by a.id,a.name

[lihan6415151528]

1楼给分了