Two ways to convert rows to SQL columns

--through Max ... Case ... When ... Converting column dataSelectStudent as 'name',MAX( CaseSubject when 'language'  ThenScoreELSE 0 END) as 'language',--Replace subject column data with score column dataMAX( CaseSubject when 'English'  ThenScoreELSE 0 END) as 'English' --Replace subject column data with score column data fromScoresGroup  byStudentOrder  byStudentSELECTStudent as 'name',    --Converting a language column with the AVG function    AVGLanguage as 'language',    --convert English columns through the AVG function    AVGEnglish as 'English' fromScores--convert data in English and Chinese to score columnsPivotAVG(score) forSubjectinch(Chinese, English)) asNewscoresGroup  byStudentOrder  byStudentASC

Two ways to convert rows to SQL columns