CREATE TABLE table_name_30 (adelaide VARCHAR, auckland VARCHAR, melbourne VARCHAR, sydney VARCHAR, perth VARCHAR)

Which Adelaide has a Sydney of yes, a Perth of no, a Melbourne of yes, and an Auckland of no?
SELECT adelaide FROM table_name_30 WHERE sydney = "yes" AND perth = "no" AND melbourne = "yes" AND auckland = "no"
SELECT "adelaide" FROM "table_name_30" WHERE "auckland" = "no" AND "melbourne" = "yes" AND "no" = "perth" AND "sydney" = "yes"