现有员工表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
查看答案
该试题由用户878****89提供
查看答案人数:21735
如遇到问题请联系客服
正确答案
该试题由用户878****89提供
查看答案人数:21736
如遇到问题请联系客服