What you have tried so far? Thanks for showing your desired result and some info about the source data. So I can provide tested code, please provide a CREATE TABLE statement and some INSERT statements so I can setup the environment on my local instance.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato