编辑代码

create database y;
use y;
create table emp(
	id int,
    worken char(10),
    name char(10),
    gender char(1),
    age int,
    idcard char(18),
    en date
);
INSERT into emp values(1,'001','曲天健','男',39,'123456789012345678','2023-09-01');
INSERT into emp values(2,'002','成鑫','女',50,'123456789012345687','2023-06-06');	
INSERT into emp values(3,'003','地头蛇','女',18,'123456789012345668','2023-05-20');
INSERT into emp values(4,'004','强龙','男',25,'123456789012345658','2023-02-06');
INSERT into emp values(5,'005','牛马','女',66,'123456789012345648','2023-11-11');
INSERT into emp values(6,'007','老六','男',55,'123456789012345638','2023-12-11');
insert into emp values(7,'008','老八','男',16,'12345678901234562x','2023-11-06');
insert into emp values(8,'009','篮球','男',19,'123456789012345618','2023-05-11');
insert into emp values(9,'006','原神胖子','男',20,'123456789012345608','2023-05-03');
insert into emp values(10,'0010','棉花','男',29,'123456789012345698','2023-06-07');
select*from emp;
select name as 姓名,age as 年龄 from emp;
select *from emp where age >=20;
select name,gender ,age from emp where gender='女' and age <25;
select name,idcard from emp where idcard like '%x';
select name from emp where name like '_六';
select*from emp where age in (20,21,22,23);
select count(*)from emp;
select count(idcard)from emp;
select sum(age)as年龄和 from emp;
select max(age)as最大年纪 from emp;
select min(age)as最小年纪 from emp;
select avg(age)as平均年纪 from emp;
select gender,max(age) from emp group  by gender;
select en,avg(age),count(en)from emp group by en;
select id,name from emp where id>5;

select gender,count(gender),sum(age) from emp where id>5
group by gender;

select gender,count(gender),sum(age) from emp group by gender;
select gender,count(gender),sum(age) from emp group by gender having 
sum(age)>200;
select gender,en,count(*)from emp group by gender,en having count(*)>1;
select *from emp where age >30;
select gender,en, max(age),count(*)from emp where age>30
group by gender,en having max(age)>35;
select age,name from emp order by age desc;
select age,name from emp order by age;
select age,name from emp order by age desc limit 3,2;
select age,name from emp