I have defined a few Asset in the printer category and Requests and problem are defined on these assets.

I want to write a Qurey on assets table  that categorizes assets by problem.(Like the attached picture)

for example :

select Asset