เมลเบิร์นคนไหนมีโกลด์โคสต์และซิดนีย์ซึ่งใช่แต่แอดิเลดที่ไม่มี?ไม่จำเป็นที่จะต้องใช้โต๊ะทั้งหมด
Which Melbourne had a gold coast and sydney which were yes but an adelaide that was no?It is not neccessary to use all the tables.
 table_name_59:  (melbourne [ VARCHAR ] sydney [ VARCHAR ] gold_coast [ VARCHAR ] adelaide [ VARCHAR) ]
SELECT melbourne FROM table_name_59 WHERE gold_coast = "yes" AND adelaide = "no" AND sydney = "yes"