sql OLAP using PIVOT

Question

HELP.. Can't get the right query for this

Amit Mohanty · Answer

Hey, try this
SELECT  Student, CAST (English  AS   DECIMAL (7,2))  AS  English,   CAST (Mathematics  AS   DECIMAL (7,2))  AS  Mathematics,   CAST (Science  AS   DECIMAL (7,2))  AS  Science,   CAST (Programming  AS   DECIMAL (7,2))  AS  Programming,   CAST (History  AS   DECIMAL (7,2))  AS  History   FROM  ( SELECT  Student, Subjects, Grades  FROM  YourTableName)Tab1     PIVOT     (          AVG (Grades)  FOR  Subjects  IN  (English,Mathematics,Science,Programming,History)   )  AS  Tab2