Convert long data to wide data in SQL?

yeah same question