phpmyadmin mysql语法，用于从具有不同where子句的多个查询创建查询

I'm attempting to join two queries with different where statements, on phpmyadmin mysql, The following is the code i need help with:I'm attempting to join two queries with differe