Need help in SQL query

See more:

SQL-Server

sir, i have a sql query related to timetable of institution like.

Select * from(
Select  c.classesid,c.code,s.Section,ss.subject,ss.subjectID,w.weekdayid,w.Weekday,Period,p.Employee from timetable t
Inner Join Classes c on c.ClassesID=T.ClassesID
Inner Join Section s on s.sectionid=t.sectionid
Inner Join Subject ss on ss.Subjectid=t.Subjectid
Inner Join Weekday w on w.Weekdayid=t.weekday
Inner Join P_employee p on p.Employeeid=t.teacherID
where t.classesid=20 and t.period=1
) as t 
pivot (
max(subject) for Period in ([1]) )as tt

the result of thid query are:

ClassesID classes section subjectid weekdayid weekday teacher [1]

20	XII(Sci)	A	1	3	Wed	Ayushmaan Khuranna	ENGLISH
20	XII(Sci)	A	1	4	Thu	Ayushmaan Khuranna	ENGLISH
20	XII(Sci)	A	1	5	Fri	Ayushmaan Khuranna	ENGLISH
20	XII(Sci)	A	1	6	Sat	Ayushmaan Khuranna	ENGLISH
20	XII(Sci)	A	2	1	Mon	Monika Rathi	HINDI
20	XII(Sci)	A	2	2	Tue	Monika Rathi	HINDI

i need to show result like :-

ClassesID classes     section       [1]
20	   XII(Sci)	      A      [HINDI(Mon-Tus)-ENGLISH(Wed-Sat)/Monika Rathi-aayushmaan khurana]

What I have tried:

i had tried pivot but its not giving a right output that i want.