将两个select查询组合在一个mysql中。

I am trying to figure out 1 query for a long time. I am new to mysql and query statements. I have below 2 queries which I would like to pass into 1 statement so that i can get the desired output.I am trying to figure out 1 query for a long ti