sql

 create database teacher;
use teacher;
create table teacher(
       id int primary key identity(1,1),
       tname varchar(50),
       tage int,
       tsex varchar(10),
       class varchar(10),
       kecheng varchar(20),
);
select *from teacher;
insert into teacher values('张三','30','男','0704班','计算机');
insert into teacher values('张三',45,'女','0701班','数理统计');
insert into teacher values('李四',35,'男','0702班','概率论');
insert into teacher values('王五',36,'女','0703班','常微分方程');
insert  into teacher(tname ,tage, tsex) values ('刘七',26,'男');
select*from teacher;
delete from teacher where tname='张三';
drop table teacher;
select *from teacher;
update teacher set tname='小花' where id=1;
select*from teacher;
update teacher set tage=tage+1;
select *from teacher;
select tname from teacher where tsex='男';
select tname,tsex ,tage from teacher where tage>30;
select avg(tage) from teacher;
select count(*)from teacher;
select *from teacher;
select min(tage)from teacher;
select *from teacher where tage=(select min(tage)from teacher);
select *from teacher;
create table class1(
       id int primary key identity(1,1),
       cname varchar(10),
       cshu int,
);
select *from class1;
insert  into class1 values('0704',56);
insert into class1 values('0703',45);
insert into class1 values('0702',30);
insert into class1(cname) values('0701');
select *from class1;
delete from class1 where id=5;
select *from class1;
insert into class1(cname)values('0705');
update class1 set cname='0706'where id=7;
create table student(
       id int primary key identity(20071,1),
       sname varchar(50),
       ssex varchar(2),
       sage int
);
drop table student;
select *from student;
insert into student values('小坏蛋','女',20);
insert into student values('小红','女',23);
insert into student values('小猪','男',22);
delete from student where sname='小坏蛋';
update student set sname='小洪'where id=20072;
select *from student;