Mysql creates a table based on the query results

Mysql creates a table based on the query results

Assume that three tables exist.

S (sno, sname. sex, age, dept) // sno indicates the student's student ID, sname indicates the student's name, sex indicates the gender, age indicates the age, and dept indicates the Department

C (cno, cname, tname) // cno course number, cname Course name, tname instructor name

SC (sno, cno, grade) // sno student ID, cno course number, grade score

There are the following requirements: Create a new basic table stu (sno, sname, dept) for the student ID, name, and system of the student whose score is greater than or equal to 80)

Create table stu (
Select sno, sname, dept from s where s. sno in (select sno from SC where SC. grade> = 80)
);