试图在SQL Query中显示两个表的计数

I'm trying to get the count from two different tables and group them together. The problem I am running into is that I either get really long query times 30 mins + or it just doesn't display the way I want it to.I'm trying to get the count from two different