MySQL Using AND Statement

I am having issues with this question:

Find the cities that have direct (non-stop) flights to both Honolulu and Newark.

enter image description here

The answer should be Dallas, since its the only location that has destinations to both Honolulu and Newark. I’m trying to use the AND statement but it wont work.

SELECT FLIGHTS.source_city FROM FLIGHTS WHERE (FLIGHTS.destination_city = 'Honolulu') and (FLIGHTS.destination_city = 'Newark') 

I am using MySQL.