mysql查询部门编号不等于80员工信息

基础查询语法：【select查询列表from表名称】。

条件查询语法：【select查询列表from表名where筛选条件】。

假如部门表名为：【department】，部门员工编号为：【depart_id】。

则部门编号不等于80员工信息的条件查询语句为：【selectdepart_idfromdepartmentwheredepart_id!=80】。

select deptid, count(*) as total from A group by deptid having sum(ewage)>500000 and avg(ewage)<6000

---