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:
Query the student ID and average scores of students whose average scores are greater than 60.

SQL statement to meet the above query requirements: