(1)题:
select 姓名,出生日期 from stuinfo where 性别=\男\出生日期)=1988 (2)题:
insert into 学生1 (学号,姓名,专业) select 学号,姓名,专业 from stuinfo where 专业=\计算机\
(3)题:
update stuinfo set 助学金=150 where 专业=\物理\性别=\男\(4)题:
select * into 学生3 from stuinfo where 专业=\计算机\year(date())-year(出生日期) desc
(1)题:
select 姓名,补助,等级 from stuinfo
where 性别=\女\是否党员=true and 补助>=50 (2)题:
select count(*) as tongji from shuinfo where 性别=\女\等级=\不及格\
(3)题:
delete from stuinfo
where 专业=\物理\性别=\男\(4)题:
SELECT *, year(Date())-year(出生日期) AS 年龄 FROM stuinfo
1)题:
select 专业,等级,学号,姓名 from stuinfo where 专业=\纺织工程\(2)题:
Select count(*) as tongji from stuinfo where 性别=\男\出生日期)=1988
(3)题:
Delete from stuinfo
where 等级=\优秀\是否党员=false (4)题:
SELECT * into 学生2 from stuinfo where 专业=\物理\order by year(Date())-year(出生日期) ASC