I am having issues with this question:
Find the cities that have direct (non-stop) flights to both Honolulu and Newark.
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.