Help with SQL query to generate a pivot

Job ID: 30845644

Budget: £10 – £20 GBP

Please see attachment for details Find count of values that exists in multiple columns as a pivot. So I have session ids which can view multiple page categories in a same session. I just want a count of sessions pivoted with page categories they viewed in the same session.
Related categories: PHP SQL MySQL Database Programming Microsoft SQL Server