user: Question: Which Perth has Gold Coast Yes, Sydney Yes, Melbourne Yes, and Adelaide Yes?
Columns: ['Sydney', 'Gold Coast', 'Adelaide', 'Melbourne', 'Perth']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Yes', 'Yes', 'Yes', 'Yes', 'Yes']
SQL:

assistant: SELECT "Perth" FROM "Table" WHERE "Gold Coast" = 'Yes' AND "Sydney" = 'Yes' AND "Melbourne" = 'Yes' AND "Adelaide" = 'Yes';