PIVOT statement in Sql 2005

Wrote my first PIVOT statement today:

SELECT *
FROM (SELECT u_id, u_firstname, u_lastname, u_email, a.ag_name, u.u_phone, u.u_jobtitle, rolename
FROM [user] u INNER JOIN
agency a ON u.u_ag_id = a.ag_id INNER JOIN
aspnet_usersinroles m ON u.u_asp_userid = m.userid INNER JOIN
aspnet_roles r ON m.roleid = r.roleid) o PIVOT (count(rolename) FOR rolename IN ([Basic], [Practitioner], [TrainingManager], [CPDManager], [Administrator], [Assessor])) p