SQL练习题1

表结构：

CREATE TABLE teachers (
tid bigint(20) NOT NULL,
tname char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
email char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
salary smallint(6) NULL DEFAULT NULL,
PRIMARY KEY (tid) USING BTREE
);

CREATE TABLE courses (
cid bigint(20) NOT NULL,
cname char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
hour char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (cid) USING BTREE
);

CREATE TABLE students (
sid bigint(20) NOT NULL,
sname char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
email char(20)