Database subqueries Practice queries between three tables

Subquery Exercises

Create a subquery between three tables for three tables

--Table I: Student table student
--School Number: Code int (primary key) starting from 1
--Name: Name varchar (50)
--Class: Banjichar (10)
--Language teacher number: Yujiaoint
--Math teacher Number: Yujiaoint
--English teacher number: Yujiaoint

--Table II: Teacher Table teacher
--Teacher Number: Codeint (primary key) starting from 1001
--Responsible Course: Lessonchar (10) (Chinese, maths, English)
--Age: Ageint
--Birthday: Birthdatetime

--Table III: SCORE Table score
--School Number: codeint (foreign key of student study number)
--Language score: Yufendecimal (18,2)
--Math Score: Shufendecimal (18,2)
--English score: Yingfendecimal (18,2)

Database subqueries Practice queries between three tables