How to get different term result in different column in sql?

Question

i want sasmahi means 6th term result

n salana means yearly result

i want to achieve something like this

 

salana 50 

salana 50

salana 50

salana 50 

sasmahi 50

sasmahi 50

sasmahi 50

sasmahi 50

 

i want in different columns

salana sashmahi

50            50 

50            50

50            50

50            50 

with subject and other fields.