将子查询返回的行作为原始列的列

I'm making a database where students can register for workshops, and I have a table WorkshopRegistration that keeps the StudentID and WorkshopID. My goal is to return a table with the columns StudentName, SchoolName, Workshop1, Workshop2. Students will never be enrolled in more than 2 workshops. I've gotten to the point of having 1 workshop as a column, but I'm having trouble getting the second one.I'm making a database where students can regist