SQL columns converted to queried rows

Query each student's (name, language, maths, English, score) for the column

The table structure is as follows:

Student: Student Table

Grade score Table:

The following effect is queried:

SQL is as follows:

Select s.name,a.* from Student S, (select Sid,max (case kemu "language ' then Chengji ELSE 0 END) ' Language ', max (case kemu when ' math ') Then Chengji else 0 end) ' Math ', max (case Kemu when ' English ' then Chengji ELSE 0 end) ' English ' from  grade GROUP by Sid Awhere S.id = A.sid

　　

SQL columns converted to queried rows