Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
select Teacher, Yearling, Autobiographer from ( select UserId, Name from Badges ) d pivot ( max(UserId) for Name in (Teacher, Yearling, Autobiographer) ) piv;