带case / COALESCE语句的SQL查询

I have query that working perfectly.but now there is situation where i have to join 2 query in case statement.but problem is one of the query is in already use.So my question how do i add this two sql in one sqlI have query that working perfectly.but now the