combining FILTER formula in Google Sheets

Question

https://docs.google.com/spreadsheets/d/1St7OTtb69rj00qsq_C7vhtSD1VEUVUL9ekAmguBcc-M/edit?usp=sharing

the case above shows:

1. there are two tables of data (city and country)
2. I can filter each of the data according to a certain category
3. I can combine both filter result manually by putting one above another

THE QUESTION:
is there any formula that can combine both filters (city and country) so that we got the expected result as shown in cell J2:J9??

Answer 1

use:

={FILTER(A:A, B:B="yes"); 
  FILTER(D:D, E:E="yes")}

---

or:

=FILTER({A:A; D:D}, {B:B; E:E}="yes")

---

or:

=QUERY({A:B; D:E}, "select Col1 where Col2 = 'yes'")