数据库查询语句及相应例题

CREATE TABLE student (
id INT(10) not NULL UNIQUE PRIMARY KEY,
`NAME` VARCHAR(20) NOT NULL,
sex VARCHAR(4),
birth YEAR,
department VARCHAR(20),
address VARCHAR(50)
);

SELECT *FROM student;
INSERT INTO student VALUES
(901,'张老大','男',1985,'计算机系','北京市海定区'),
(902,'张老二','男',1986,'中文系','北京市昌平区'),
(903,'张三','女',1990,'中文系','湖南省永州市'),
(904,'李四','男',1990,'英语系','辽宁省阜新市'),
(905,'王五','女',1991,'英语系','福建省厦门市'),
(906,'王六','男',1988,'计算机系','湖南省痕阳市');


CREATE TABLE score(
id INT(10) PRIMARY KEY auto_increment,
stu_id INT(10) NOT NULL,
c_name VARCHAR(20),
grade INT(10)
);

INSERT INTO score VALUES
(N