Several SQL statements

1. Conversion of rows and columns (name varchar (10), subject varchar (10), score int), 74), 83), 93 ),, 77), 84), 94), 81), 86), 91) Name, score) as language, score) as mathematics, score) as physical from Score groupby name score (max (Points

1. Conversion of rows and columns (name varchar (10), subject varchar (10), score int), 74), 83), 93 ),, 77), 84), 94), 81), 86), 91) Name, score) as language, score) as mathematics, score) as physical from score group by name score (max (Points

1. Conversion of rows and columns

Score (name varchar (10), subject varchar (10), score int), 74), 83), 93), 77), 84 ),, 94), 81), 86), 91) Name, score) as language, score) as mathematics, score) as physical from score group by name score (max (score) for subject in (Chinese, Mathematics, Physics) a score (name varchar (10), Chinese int, math int, physical int), 93), 94), 86, 91) Name, subject, language as score from Score subject, mathematics as score from Score subject, physical as score from Score name, subject, score from Score Untitled (score for subject in (language, mathematics, physics) t,