Thanks for the tip Chris, I have never come across the CASE command before.

was easy in the end 🙂

select r.r_age_group, r.r_event, p.firstname + ' ' + p.surname,

sum(case when...