现有员工表
A,包含员工(staff _id) 和部门 id(section id)两字段, 部门
B,包含部门 id(section id) 和部门所在城市(city)两字段,若想要查询该公司每个城市的员工数,以下语句可以实现的是?
A.select city,count(staff_ id) from A join в on A .section_ id= B section_ id group by section id; B.select city,count(staff id) from A join в on A .section id=B .section_ id group by city; C.select city,count(staff_ id) from A join в where A section_ id =B .section_ id group by section id; D.se1ect city,count(staff_ id) from正确答案B
A,B group by city;