现有员工表A,包含员Iidstatfjd)和部门id(sectionjd)两李段部门表B.包含部门id(section,id)和部所在城市(ity)两字段,若想要查询该公司每个城市的员工数以下语句可以实现的是?单选()
A.select city, count(staff_id) from AjoinB on A.section_id = B. section_id group by B. section: B.select city, count(staff id) from A.B group by city; C.selet city,count(staff_id) from A join B where A.section_id=B. section_id group by city; D.select city.count(staff_id) from A join B on A.section_id = B.section_id group by city