Bar chart with non time series data from MySQL

Hey guys,
i am pretty new to Grafana and struggeling to get a bar chart working.

I made this MySQL Query which i want to display with grafana.

How do i “transform” this SQL Query into the Grafana Query Builder to get a bar chart? Is this even possible?

I am using Grafana v8.2.5

Should look alike this: