Table Creation Statements:

CREATE TABLE sc (
sid varchar(10) DEFAULT NULL COMMENT ‘student ID’,
cid varchar(10) DEFAULT NULL COMMENT ‘course ID’,
score decimal(18,1) DEFAULT NULL COMMENT ‘score’
) ENGINE=InnoDB COMMENT=‘score information table’;\n
CREATE TABLE course (
cid varchar(10) DEFAULT NULL COMMENT ‘course ID’,
cname varchar(10) DEFAULT NULL COMMENT ‘course name’,
tid varchar(10) DEFAULT NULL COMMENT ‘teacher ID’
) ENGINE=InnoDB COMMENT=‘course information table’;\n
CREATE TABLE student (
sid varchar(10) DEFAULT NULL COMMENT ‘student ID’,
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 COMMENT=‘student information table’;\n
CREATE TABLE teacher (
tid varchar(10) DEFAULT NULL COMMENT ‘teacher ID’,
tname varchar(10) DEFAULT NULL COMMENT ‘teacher name’
) ENGINE=InnoDB COMMENT=‘teacher information table’;\n

Query Text: Find all the student IDs who have a higher score in course “01” than in course “02”

SQL query that satisfies the above query requirement: Avoid using the following keywords: date, innodb, text, sc
user