MySQL第二次作业

select * from t_worker;

select distinct department_id from t_worker;

select count(1) from t_worker;

select max(wages),min(wages) from t_worker;

select avg(wages),sum(wages) from t_worker;

create table work_date as select worker_id,name,worker_date from t_worker;

select year(now()) - year(borth_date) as '年龄' from t_worker where politics = '党员';

select name from t_worker where wages between 4000 and 8000;

select name from t_worker where name like '孙%' or name like '李%';

select worker_id, name from t_worker where department_id in (102,103) and politics != '党员';

select * from t_worker order by borth_date;

select worker_id,name from t_worker order by wages limit 3;

select department_id, count(*) as 人数 from t_worker where politics = '党员' group by department_id;

select round(sum(wages),2),round(avg(wages),2) from t_worker group by department_id;

select department_id,count(*) from t_worker group by department_id having count(*) >= 3;