Table creation statements:

CREATE TABLE sc (
sid varchar(10) DEFAULT NULL COMMENT ‘Student number’,
cid varchar(10) DEFAULT NULL COMMENT ‘Course number’,
score decimal(18,1) DEFAULT NULL COMMENT ‘Score’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=‘Grade information table’
CREATE TABLE course (
cid varchar(10) DEFAULT NULL COMMENT ‘Course number’,
cname varchar(10) DEFAULT NULL COMMENT ‘Course name’,
tid varchar(10) DEFAULT NULL COMMENT ‘Teacher number’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=‘Course information table’
CREATE TABLE student (
sid varchar(10) DEFAULT NULL COMMENT ‘Student number’,
sname varchar(10) DEFAULT NULL COMMENT ‘Student name’,
sage datetime DEFAULT NULL COMMENT ‘Date of birth’,
ssex varchar(10) DEFAULT NULL COMMENT ‘Student gender’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=‘Student table’
CREATE TABLE teacher (
tid varchar(10) DEFAULT NULL COMMENT ‘Teacher number’,
tname varchar(10) DEFAULT NULL COMMENT ‘Teacher name’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT=‘Teacher information table’

Query text:
Query the student number and name of students whose score in course number “01” is lower than that of course number “02”.

SQL statement that satisfies the above query requirements: