sql语句
create table Students ( stu_id int identity(2010181001,1) not null primary key, stu_name varchar(12) not null, stu_age int not null, stu_math int not null, stu_english int not null, stu_chinese int not null, stu_score int null ); insert into Students values('张三',18,88,99,67); insert into Students values('李四',15,78,99,87); insert into Students values('王五',21,68,99,77); insert into Students values('找六',15,58,99,87);
现在想写条查询语句,查询所有信息,stu_score是stu_math,stu_english,stu_chinese三项的总和
select stu_id as 学号,stu_name as 姓名,stu_age as 年龄,stu_math as 数学,stu_english as 英语,stu_chinese as 语文,stu_score from Students;
stu_score该怎么写呢?