Gold Coast ของ Syndney, Adelaide, Melbourne และ Auckland ล้วนไม่มีใช่หรือไม่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Which Syndney's Gold coast, Adelaide, Melbourne, and Auckland were all no?It is not neccessary to use all the tables.
 table_name_47:  sydney [ VARCHAR]  auckland [ VARCHAR]  melbourne [ VARCHAR]  gold_coast [ VARCHAR]  adelaide [ VARCHAR] 
SELECT sydney FROM table_name_47 WHERE gold_coast = "no" AND adelaide = "no" AND melbourne = "no" AND auckland = "no"