I have problems with this question:
Find cities with direct flights to Honolulu and Newark.
The answer should be Dallas, as it is the only location that has both destinations as well as Honolulu and Newark. I try that
AND Statement, but it will not work.
SELECT FLIGHTS.source_city OF FLIGHTS WO (FLIGHTS.destination_city = # Honolulu #) and (FLIGHTS.destination_city = # Newark #)
I use MySQL.