Table: Info

![Table](https://i.stack.imgur.com/UEpyh.jpg)

Sample Output:

![Sample Output](https://i.stack.imgur.com/yQi6p.jpg)

This is a college exercise. I have just started learning SQL and don't understand how can you select data from two different rows of a column and create different columns in the sample output. My attempt is completely useless so I'm not putting it here as I only know how to select separate columns. 

Thank you in advance