条件过滤
相关语句知识
查询员工平均工资在2500至7000的部门
select dept_id,avg(salary)
from employees
where salary between 2500 and 7000
group by dept_id
having count(*) > 1;
查询名字叫张三的员工的记录
相关语句知识
查询员工平均工资在2500至7000的部门
select dept_id,avg(salary)
from employees
where salary between 2500 and 7000
group by dept_id
having count(*) > 1;
查询名字叫张三的员工的记录