sql创建表格

新学期开始学习sql，努力学习，天天向上

表格如图片所示

create table student(
   sno char(3), 
   sname char(10), 
   Ssex  varchar(10), 
   sbirthday datetime, 
   class char(5), 
);
insert into student(sno,sname,Ssex,sbirthday,class)values('108', '曾华', '男', '1977-09-01', '95033');
insert into student(sno,sname,Ssex,sbirthday,class)values('105', '匡明', '男', '1975-10-02', '95031');
insert into student(sno,sname,Ssex,sbirthday,class)values('107', '王丽', '女', '1976-09-01', '95033');
insert into student(sno,sname,Ssex,sbirthday,class)values('101', '李军', '男', '1976-02-20', '95033');
insert into student(sno,sname,Ssex,sbirthday,class)values('109', '王芳', '女', '1975-02-10', '95031');
insert into student(sno,sname,Ssex,sbirthday,class)values('103', '陆君', '男', '1974-06-03', '95031');

输入代码：select * from student;

显示如图所示：

新建一个课程表：如图所示

代码如下：

create table course(
   cno char(5), 
   cname varchar(10), 
   Tno  char(3),  
);
insert into course(cno,cname,Tno)values('3-105', '计算机导论', '825');
insert into course(cno,cname,Tno)values('3-245', '操作系统', '804');
insert into course(cno,cname,Tno)values('6-166', '数字电路', '856');
insert into course(cno,cname,Tno)values('9-888', '计算机导论', '825');

在新建一个成绩表：

代码如下：

create table Score(
   Sno char(5), 
   Cno char(5), 
   Degree decimal(4,1),  
);
insert into Score(Sno,Cno, Degree)values('105', '3-245', '86');
insert into Score(Sno,Cno, Degree)values('105', '3-245', '75');
insert into Score(Sno,Cno, Degree)values('109', '3-245', '68');
insert into Score(Sno,Cno, Degree)values('103', '3-105', '92');
insert into Score(Sno,Cno, Degree)values('105', '3-105', '88');
insert into Score(Sno,Cno, Degree)values('109', '3-105', '76');
insert into Score(Sno,Cno, Degree)values('101', '3-105', '64');
insert into Score(Sno,Cno, Degree)values('107', '3-105', '91');
insert into Score(Sno,Cno, Degree)values('108', '3-105', '78');
insert into Score(Sno,Cno, Degree)values('101', '6-166', '85');
insert into Score(Sno,Cno, Degree)values('107', '6-166', '79');
insert into Score(Sno,Cno, Degree)values('108', '6-166', '81');

在新建一个教师表：

代码如下：

create table teacher(
   Tno char(3), 
   Tname char(4), 
   Tsex  varchar(2), 
   Tbirthday datetime, 
   Prof char(6),
   Depart varchar(10),
);
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('804', '李诚', '男', '1958-12-10', '副教授','计算机系');
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('856', '张旭', '男', '1969-03-12', '讲师','电子工程系');
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('825', '王萍', '女', '1972-05-05', '助教','计算机系');
insert into teacher(Tno,Tname,Tsex,Tbirthday,Prof,Depart)values('831', '刘冰', '女', '1977-08-14', '助教','电子工程系');

问题1：查询Student表中的所有记录的Sname、Ssex和Class列

代码如下：

select sname,Ssex,class from student;